one PO line location id returns 4 shipment lines
Hi,
My company using dropships for sales order type, and want to add receipt number on invoice.
This is my Query
Select receipt_num, ool.line_id, INTERFACE_LINE_ATTRIBUTE6, rsl.* From
oe_order_headers_all ooh,
oe_order_lines_all ool,
oe_drop_ship_Sources odss,
ra_customer_trx_lines_all rctl ,
rcv_shipment_lines rsl,
rcv_shipment_headers rsh
Where ooh.header_id = ool.header_id
AND ool.Header_id = odss.header_id
AND OOL.LINE_ID = ODSS.LINE_ID
and rctl.customer_trx_id = 151162
and rsl.po_line_location_id = 81610
and rctl.INTERFACE_LINE_ATTRIBUTE11 = 0
and ool.line_id = rctl.INTERFACE_LINE_ATTRIBUTE6
My company using dropships for sales order type, and want to add receipt number on invoice.
This is my Query
Select receipt_num, ool.line_id, INTERFACE_LINE_ATTRIBUTE6, rsl.* From
oe_order_headers_all ooh,
oe_order_lines_all ool,
oe_drop_ship_Sources odss,
ra_customer_trx_lines_all rctl ,
rcv_shipment_lines rsl,
rcv_shipment_headers rsh
Where ooh.header_id = ool.header_id
AND ool.Header_id = odss.header_id
AND OOL.LINE_ID = ODSS.LINE_ID
and rctl.customer_trx_id = 151162
and rsl.po_line_location_id = 81610
and rctl.INTERFACE_LINE_ATTRIBUTE11 = 0
and ool.line_id = rctl.INTERFACE_LINE_ATTRIBUTE6
0