APPS.JMF_SHIKYU_GRP dependencies on MTL_INTERORG_PARAMETERS

Line 151: FROM mtl_interorg_parameters mip, jmf_subcontract_orders jso

147: /* 12.1 - Buy/Sell Subcontracting - Changes */
148: /* For Buy/Sell subcontracting - return the purchase price variance account*/
149: SELECT mip.subcontracting_type, jso.oem_organization_id
150: INTO l_subcontracting_type , l_oem_organization_id
151: FROM mtl_interorg_parameters mip, jmf_subcontract_orders jso
152: WHERE jso.subcontract_po_shipment_id = p_po_shipment_id
153: AND jso.oem_organization_id = mip.from_organization_id
154: AND jso.tp_organization_id = mip.to_organization_id;
155:

Line 181: FROM mtl_interorg_parameters mip,

177: /* return the chargeable subcontracting variance account */
178: x_subcontracting_type := 1 ; -- Bug 6679369
179: SELECT mip.shikyu_oem_var_account_id
180: INTO x_variance_account
181: FROM mtl_interorg_parameters mip,
182: jmf_subcontract_orders jso
183: WHERE jso.subcontract_po_shipment_id = p_po_shipment_id
184: AND jso.oem_organization_id = mip.from_organization_id
185: AND jso.tp_organization_id = mip.to_organization_id;

Line 331: FROM mtl_interorg_parameters mip, jmf_subcontract_orders jso

327: --
328: BEGIN
329: SELECT jso.oem_organization_id
330: INTO l_oem_org_id
331: FROM mtl_interorg_parameters mip, jmf_subcontract_orders jso
332: WHERE jso.subcontract_po_shipment_id = p_po_shipment_id
333: AND jso.oem_organization_id = mip.from_organization_id
334: AND jso.tp_organization_id = mip.to_organization_id;
335: EXCEPTION

Line 1177: FROM mtl_interorg_parameters mip

1173:
1174:
1175: SELECT mip.subcontracting_type
1176: INTO l_subcontracting_type
1177: FROM mtl_interorg_parameters mip
1178: WHERE mip.from_organization_id = p_oem_org_id
1179: AND mip.to_organization_id = p_mp_org_id;
1180:
1181: IF g_fnd_debug = 'Y' AND