DBA Data[Home] [Help]

APPS.RCV_GML_CONV_MIG dependencies on RCV_SHIPMENT_LINES

Line 98: rcv_shipment_lines rsl,

94: rsl.locator_id locator_id,
95: rlt.correction_transaction_id,
96: rlt.source_transaction_id
97: FROM rcv_lot_transactions rlt ,
98: rcv_shipment_lines rsl,
99: mtl_parameters mp
100: WHERE rlt.lot_transaction_type = 'SHIPMENT'
101: and rsl.shipment_line_id = rlt.shipment_line_id
102: and (rlt.sublot_num <> '-1' or rlt.sublot_num IS NULL)

Line 387: rcv_shipment_lines rsl,

383: rls.reason_code,
384: rsl.item_id
385: FROM rcv_transactions rt ,
386: rcv_lots_supply rls,
387: rcv_shipment_lines rsl,
388: mtl_parameters mp
389: WHERE rls.supply_type_code = 'RECEIVING'
390: and rls.transaction_id = rt.transaction_id
391: and (rls.sublot_num <> '-1' or rls.sublot_num IS NULL)

Line 416: rcv_shipment_lines rsl,

412: rsl.locator_id locator_id,
413: rlt.reason_code reason_code,
414: rlt.transaction_id
415: from rcv_lots_supply rlt ,
416: rcv_shipment_lines rsl,
417: mtl_parameters mp
418: WHERE rlt.supply_type_code = 'SHIPMENT'
419: and rsl.shipment_line_id = rlt.shipment_line_id
420: and (rlt.sublot_num <> '-1' or rlt.sublot_num is NULL)