DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on JMF_SHIKYU_COMPONENTS

Line 1647: from JMF_SHIKYU_COMPONENTS jsc, JMF_SUBCONTRACT_ORDERS jso

1643:
1644: -- cursor definitions
1645: cursor c_subcontract_po_shikyu_comp is
1646: select jsc.SHIKYU_COMPONENT_ID shikyu_component_id, jso.TP_ORGANIZATION_ID tp_organization_id, jsc.PRIMARY_UOM primary_uom
1647: from JMF_SHIKYU_COMPONENTS jsc, JMF_SUBCONTRACT_ORDERS jso
1648: where jsc.SUBCONTRACT_PO_SHIPMENT_ID = p_po_shipment_id
1649: and jso.subcontract_po_shipment_id = jsc.SUBCONTRACT_PO_SHIPMENT_ID;
1650:
1651: BEGIN