APPS.RCV_GML_CONV_MIG dependencies on MTL_PARAMETERS

Line 76: -- mtl_parameters mp

72: -- rt.locator_id locator_id,
73: -- rlt.correction_transaction_id
74: -- FROM rcv_transactions rt ,
75: -- rcv_lot_transactions rlt,
76: -- mtl_parameters mp
77: -- WHERE rlt.lot_transaction_type = 'TRANSACTION'
78: -- and rlt.source_transaction_id = rt.transaction_id
79: -- and (rlt.sublot_num <> '-1' or rlt.sublot_num is NULL)
80: -- and rt.organization_id = mp.organization_id

Line 115: mtl_parameters mp

111: ic_item_mst_b_mig mitm,
112: ic_lots_mst_mig mlot,
113: rcv_transactions rt ,
114: rcv_lot_transactions rlt,
115: mtl_parameters mp
116: WHERE
117: mitm.organization_id = mlot.organization_id
118: AND mitm.item_id = mlot.item_id
119: AND rlt.item_id = mitm.inventory_item_id

Line 157: mtl_parameters mp

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

Line 188: mtl_parameters mp

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
192: AND rlt.item_id = mitm.inventory_item_id

Line 396: mtl_parameters mp

392: rs.shipment_line_id ,
393: rs.rcv_transaction_id
394: FROM rcv_supply rs ,
395: mtl_system_items_b msi,
396: mtl_parameters mp
397: WHERE nvl(rs.quantity,0) <> 0
398: AND rs.secondary_quantity is null
399: AND rs.item_id = msi.INVENTORY_ITEM_ID
400: AND msi.ORGANIZATION_ID = to_organization_id

Line 502: mtl_parameters mp

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

Line 538: mtl_parameters mp

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