Query for to find out AR invoice and Sales Order Details
SELECT oha.order_number,
ola.line_number so_line_number,
ola.ordered_item item_name,
ola.ordered_quantity * ola.unit_selling_price LINE_AMOUNT,
rcta.trx_number Transaction_number, rcta.trx_date,
rctla.line_number TRX_line_number,
rctla.unit_selling_price unit_selling_price
FROM oe_order_headers_all oha,
oe_order_lines_all ola,
ra_customer_trx_all rcta,
ra_customer_trx_lines_all rctla
WHERE oha.header_id = ola.header_id
AND rcta.customer_trx_id = rctla.customer_trx_id
AND rctla.interface_line_attribute6 = TO_CHAR (ola.line_id)
AND rctla.interface_line_attribute1 = TO_CHAR (oha.order_number)
AND order_number = :p_order_number
This comment has been removed by the author.
ReplyDeleteOne more useful website to learn tally....
ReplyDeleteHave one sales activity for every day, since you know you can finish that. Each activity will expand upon the one from the earlier day. sales automation
ReplyDeleteThank you so much for this useful query..! appreciate it..!
ReplyDeleteI make no apology for this requirement. The most common issue I have seen in all my years as a counselor with the numerous people I have seen as clients dealing with relationships, has been inequality between couples. what to talk to a girl about
ReplyDeleteYou should appreciate, doing what makes the other person be aware of the fact they are special is easily done, on condition that we do it https://relationadvisor.com/
ReplyDelete