Creating a blog is not just a hobby it’s a partnership to grow together.
Thursday, November 21, 2013
OM - AR Drill Down
SELECT Rl.Customer_Trx_Line_Id,
Rl.Customer_Trx_Id,
Rl.Line_Number,
rh.trx_number,
Rl.Interface_Line_Attribute1,
H.Order_Number,
L.Line_Id,
Rl.Sales_Order_Line,
rl.quantity_ordered,
rl.quantity_invoiced,
Rl.Extended_Amount
FROM Ra_Customer_Trx_Lines_All Rl,
RA_CUSTOMER_TRX_ALL rh,
oe_order_lines_all l,
oe_order_headers_all h
WHERE line_type = 'LINE'
AND interface_line_context = 'ORDER ENTRY'
AND h.header_id = l.header_id
AND interface_line_attribute6 = TO_CHAR (l.line_id)
AND Interface_Line_Attribute1 = TO_CHAR (H.Order_Number)
AND rh.customer_trx_id = rl.customer_trx_id
AND sales_order = h.order_number
and h.order_number = 13001107374
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment