DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on JMF_SHIKYU_COMPONENTS

Line 87: FROM JMF_SHIKYU_COMPONENTS

83: , SHIKYU_COMPONENT_ID
84: , OEM_ORGANIZATION_ID
85: , SHIKYU_COMPONENT_PRICE
86: , PRIMARY_UOM
87: FROM JMF_SHIKYU_COMPONENTS
88: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_SUBCONTRACT_PO_SHIPMENT_ID
89: ;
90:
91: l_reduced_allocations_tbl

Line 931: FROM jmf_shikyu_components

927: CURSOR C_SHIKYU_components_CSR IS
928: SELECT SUBCONTRACT_PO_SHIPMENT_ID
929: , SHIKYU_COMPONENT_ID
930: , OEM_ORGANIZATION_ID
931: FROM jmf_shikyu_components
932: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_SUBCONTRACT_PO_SHIPMENT_ID
933: order by SHIKYU_COMPONENT_ID ;
934:
935: l_deleted_allocations_tbl JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type ;

Line 1371: FROM JMF_SHIKYU_COMPONENTS

1367: , SHIKYU_COMPONENT_ID
1368: , OEM_ORGANIZATION_ID
1369: , SHIKYU_COMPONENT_PRICE
1370: , PRIMARY_UOM
1371: FROM JMF_SHIKYU_COMPONENTS
1372: WHERE SUBCONTRACT_PO_SHIPMENT_ID = l_subcontract_po_shipment_id ;
1373:
1374: l_used_quantity NUMBER;
1375: