DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on RCV_SHIPMENT_LINES

Line 2195: FROM rcv_shipment_lines rsl

2191: FROM rcv_shipment_headers rsh , rcv_transactions rt
2192: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2193: (SELECT rsh.shipment_header_id,
2194: rsl.shipment_line_id -- rt.transaction_id
2195: FROM rcv_shipment_lines rsl
2196: WHERE rsl.po_header_id = p_sample_rec.po_header_id
2197: AND rsl.item_id IN
2198: (SELECT msi.inventory_item_id
2199: FROM mtl_system_items msi

Line 2214: FROM rcv_shipment_lines rsl

2210: FROM rcv_shipment_headers rsh
2211: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2212: (SELECT rsh.shipment_header_id,
2213: rsl.shipment_line_id
2214: FROM rcv_shipment_lines rsl
2215: WHERE rsl.po_header_id = p_sample_rec.po_header_id
2216: AND rsl.item_id = p_sample_rec.inventory_item_id
2217: AND rsl.po_line_id = p_sample_rec.po_line_id
2218: AND rsl.shipment_header_id = rsh.shipment_header_id);