APPS.JMF_SHIKYU_UTIL dependencies on JMF_SUBCONTRACT_ORDERS

Line 143: UPDATE JMF_SUBCONTRACT_ORDERS sco

139: , 'IN');
140: END IF;
141:
142:
143: UPDATE JMF_SUBCONTRACT_ORDERS sco
144: SET sco.INTERLOCK_STATUS = 'T'
145: WHERE sco.INTERLOCK_STATUS IN ('N','E','U' )
146: AND sco.SUBCONTRACT_PO_SHIPMENT_ID IN
147: ( SELECT poll.line_location_id

Line 729: FROM JMF_SUBCONTRACT_ORDERS jso

725: SELECT jso.oem_organization_id,
726: jso.tp_organization_id
727: INTO x_oem_organization_id,
728: x_tp_organization_id
729: FROM JMF_SUBCONTRACT_ORDERS jso
730: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;
731:
732: EXCEPTION
733: WHEN NO_DATA_FOUND THEN

Line 1102: jmf_subcontract_orders jso

1098: -- to MP Organizations
1099: SELECT mip.shikyu_tp_offset_account_id
1100: INTO x_offset_account
1101: FROM mtl_interorg_parameters mip,
1102: jmf_subcontract_orders jso
1103: WHERE jso.subcontract_po_shipment_id = p_po_shipment_id
1104: AND jso.oem_organization_id = mip.from_organization_id
1105: AND jso.tp_organization_id = mip.to_organization_id
1106: --AND mip.shikyu_enabled_flag = 'Y';