DBA Data[Home] [Help]

APPS.RCV_GML_CONV_MIG dependencies on RCV_SHIPMENT_LINES

Line 156: rcv_shipment_lines rsl,

152: rsl.locator_id locator_id,
153: rlt.correction_transaction_id,
154: rlt.source_transaction_id
155: FROM rcv_lot_transactions rlt ,
156: rcv_shipment_lines rsl,
157: mtl_parameters mp
158: WHERE rlt.lot_transaction_type = 'SHIPMENT'
159: and rsl.shipment_line_id = rlt.shipment_line_id
160: and (rlt.sublot_num <> '-1' or rlt.sublot_num IS NULL)

Line 187: rcv_shipment_lines rsl,

183: FROM
184: ic_lots_mst_mig mlot,
185: ic_item_mst_b_mig mitm,
186: rcv_lot_transactions rlt ,
187: rcv_shipment_lines rsl,
188: mtl_parameters mp
189: WHERE
190: mitm.organization_id = mlot.organization_id
191: AND mitm.item_id = mlot.item_id

Line 501: rcv_shipment_lines rsl,

497: rls.reason_code,
498: rsl.item_id
499: FROM rcv_transactions rt ,
500: rcv_lots_supply rls,
501: rcv_shipment_lines rsl,
502: mtl_parameters mp
503: WHERE rls.supply_type_code = 'RECEIVING'
504: and rls.transaction_id = rt.transaction_id
505: and (rls.sublot_num <> '-1' or rls.sublot_num IS NULL)

Line 537: rcv_shipment_lines rsl,

533: rsl.locator_id locator_id,
534: rlt.reason_code reason_code,
535: rlt.transaction_id
536: from rcv_lots_supply rlt ,
537: rcv_shipment_lines rsl,
538: mtl_parameters mp
539: WHERE rlt.supply_type_code = 'SHIPMENT'
540: and rsl.shipment_line_id = rlt.shipment_line_id
541: and (rlt.sublot_num <> '-1' or rlt.sublot_num is NULL)