APPS.CSTPPINV dependencies on MTL_INTERORG_PARAMETERS

Line 125: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT

121: l_stmt_num := 50;
122: IF (i_txn_action_id in( 21,22)) THEN -- INVCONV sikhanna
123: SELECT nvl(MMT.fob_point, MIP.fob_point)
124: INTO l_fob_point
125: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT
126: WHERE MIP.from_organization_id = i_txn_org_id
127: AND MIP.to_organization_id = i_txfr_org_id
128: AND MMT.transaction_id = i_txn_id;
129: ELSIF (i_txn_action_id in (12,15)) THEN

Line 132: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT

128: AND MMT.transaction_id = i_txn_id;
129: ELSIF (i_txn_action_id in (12,15)) THEN
130: SELECT nvl(MMT.fob_point, MIP.fob_point)
131: INTO l_fob_point
132: FROM mtl_interorg_parameters MIP, mtl_material_transactions MMT
133: WHERE MIP.from_organization_id = i_txfr_org_id
134: AND MIP.to_organization_id = i_txn_org_id
135: AND MMT.transaction_id = i_txn_id;
136: ELSE

Line 766: mtl_interorg_parameters mip

762: /* Get FOB Point */
763: SELECT nvl(mmt.fob_point,mip.fob_point)
764: INTO l_fob_point
765: FROM mtl_material_transactions mmt,
766: mtl_interorg_parameters mip
767: WHERE mmt.transaction_id = i_txn_id
768: AND mip.from_organization_id = l_from_org
769: AND mip.to_organization_id = l_to_org;
770:

Line 2872: FROM mtl_interorg_parameters mip,

2868: AND ccga1.organization_id = mmt.organization_id
2869: AND mmt.primary_quantity > 0))
2870: OR (mmt.transaction_action_id = 21
2871: AND EXISTS ( SELECT 'X'
2872: FROM mtl_interorg_parameters mip,
2873: cst_cost_group_assignments ccga2
2874: WHERE mip.from_organization_id = mmt.organization_id
2875: AND mip.to_organization_id = mmt.transfer_organization_id
2876: AND NVL(mmt.fob_point,mip.fob_point) = 1

Line 2881: FROM mtl_interorg_parameters mip,

2877: AND ccga2.organization_id = mip.to_organization_id
2878: AND ccga2.cost_group_id = i_cost_group_id))
2879: OR (mmt.transaction_action_id = 12
2880: AND EXISTS ( SELECT 'X'
2881: FROM mtl_interorg_parameters mip,
2882: cst_cost_group_assignments ccga2
2883: WHERE mip.from_organization_id = mmt.transfer_organization_id
2884: AND mip.to_organization_id = mmt.organization_id
2885: AND NVL(mmt.fob_point,mip.fob_point) = 2

Line 3264: FROM mtl_interorg_parameters mip

3260: AND ccga2.cost_group_id = i_cost_group_id))
3261: OR (mmt.transaction_action_id = 12
3262: AND EXISTS (
3263: SELECT 'X'
3264: FROM mtl_interorg_parameters mip
3265: WHERE mip.from_organization_id = mmt.transfer_organization_id
3266: AND mip.to_organization_id = mmt.organization_id
3267: AND (
3268: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (