DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on RCV_SHIPMENT_LINES

Line 2325: FROM rcv_shipment_lines rsl

2321: FROM rcv_shipment_headers rsh , rcv_transactions rt
2322: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2323: (SELECT rsh.shipment_header_id,
2324: rsl.shipment_line_id -- rt.transaction_id
2325: FROM rcv_shipment_lines rsl
2326: WHERE rsl.po_header_id = p_sample_rec.po_header_id
2327: AND rsl.item_id IN
2328: (SELECT msi.inventory_item_id
2329: FROM mtl_system_items msi

Line 2344: FROM rcv_shipment_lines rsl

2340: FROM rcv_shipment_headers rsh
2341: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2342: (SELECT rsh.shipment_header_id,
2343: rsl.shipment_line_id
2344: FROM rcv_shipment_lines rsl
2345: WHERE rsl.po_header_id = p_sample_rec.po_header_id
2346: AND rsl.item_id = p_sample_rec.inventory_item_id
2347: AND rsl.po_line_id = p_sample_rec.po_line_id
2348: AND rsl.shipment_header_id = rsh.shipment_header_id);