DBA Data[Home] [Help]

APPS.RCV_GML_CONV_MIG dependencies on MTL_PARAMETERS

Line 70: mtl_parameters mp

66: rt.locator_id locator_id,
67: rlt.correction_transaction_id
68: FROM rcv_transactions rt ,
69: rcv_lot_transactions rlt,
70: mtl_parameters mp
71: WHERE rlt.lot_transaction_type = 'TRANSACTION'
72: and rlt.source_transaction_id = rt.transaction_id
73: and (rlt.sublot_num <> '-1' or rlt.sublot_num is NULL)
74: and rt.organization_id = mp.organization_id

Line 99: mtl_parameters mp

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)
103: and rsl.to_organization_id = mp.organization_id

Line 282: mtl_parameters mp

278: rs.shipment_line_id ,
279: rs.rcv_transaction_id
280: FROM rcv_supply rs ,
281: mtl_system_items_b msi,
282: mtl_parameters mp
283: WHERE nvl(rs.quantity,0) <> 0
284: AND rs.secondary_quantity is null
285: AND rs.item_id = msi.INVENTORY_ITEM_ID
286: AND msi.ORGANIZATION_ID = to_organization_id

Line 388: mtl_parameters mp

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)
392: AND rt.organization_id = mp.organization_id

Line 417: mtl_parameters mp

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)
421: AND mp.organization_id = rsl.to_organization_id