APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on JMF_SHIKYU_COMPONENTS

Line 1602: from JMF_SHIKYU_COMPONENTS jsc, JMF_SUBCONTRACT_ORDERS jso

1598:
1599: -- cursor definitions
1600: cursor c_subcontract_po_shikyu_comp is
1601: select jsc.SHIKYU_COMPONENT_ID shikyu_component_id, jso.TP_ORGANIZATION_ID tp_organization_id, jsc.PRIMARY_UOM primary_uom
1602: from JMF_SHIKYU_COMPONENTS jsc, JMF_SUBCONTRACT_ORDERS jso
1603: where jsc.SUBCONTRACT_PO_SHIPMENT_ID = p_po_shipment_id
1604: and jso.subcontract_po_shipment_id = jsc.SUBCONTRACT_PO_SHIPMENT_ID;
1605:
1606: BEGIN