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 808: mtl_interorg_parameters mip

804: /* Get FOB Point */
805: SELECT nvl(mmt.fob_point,mip.fob_point)
806: INTO l_fob_point
807: FROM mtl_material_transactions mmt,
808: mtl_interorg_parameters mip
809: WHERE mmt.transaction_id = i_txn_id
810: AND mip.from_organization_id = l_from_org
811: AND mip.to_organization_id = l_to_org;
812:

Line 2922: FROM mtl_interorg_parameters mip,

2918: AND ccga1.organization_id = mmt.organization_id
2919: AND mmt.primary_quantity > 0))
2920: OR (mmt.transaction_action_id = 21
2921: AND EXISTS ( SELECT 'X'
2922: FROM mtl_interorg_parameters mip,
2923: cst_cost_group_assignments ccga2
2924: WHERE mip.from_organization_id = mmt.organization_id
2925: AND mip.to_organization_id = mmt.transfer_organization_id
2926: AND NVL(mmt.fob_point,mip.fob_point) = 1

Line 2931: FROM mtl_interorg_parameters mip,

2927: AND ccga2.organization_id = mip.to_organization_id
2928: AND ccga2.cost_group_id = i_cost_group_id))
2929: OR (mmt.transaction_action_id = 12
2930: AND EXISTS ( SELECT 'X'
2931: FROM mtl_interorg_parameters mip,
2932: cst_cost_group_assignments ccga2
2933: WHERE mip.from_organization_id = mmt.transfer_organization_id
2934: AND mip.to_organization_id = mmt.organization_id
2935: AND NVL(mmt.fob_point,mip.fob_point) = 2

Line 3316: FROM mtl_interorg_parameters mip

3312: AND ccga2.cost_group_id = i_cost_group_id))
3313: OR (mmt.transaction_action_id = 12
3314: AND EXISTS (
3315: SELECT 'X'
3316: FROM mtl_interorg_parameters mip
3317: WHERE mip.from_organization_id = mmt.transfer_organization_id
3318: AND mip.to_organization_id = mmt.organization_id
3319: AND (
3320: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (