DBA Data[Home] [Help]

APPS.BOM_BOMRBOMC_XMLP_PKG dependencies on MTL_ITEM_REVISIONS

Line 13: MTL_ITEM_REVISIONS MIR

9: CURSOR C1 IS
10: SELECT
11: REVISION
12: FROM
13: MTL_ITEM_REVISIONS MIR
14: WHERE INVENTORY_ITEM_ID = ITEM_ID
15: AND ORGANIZATION_ID = ORG_ID
16: AND MIR.EFFECTIVITY_DATE <= TO_DATE(LP_REVISION_DATE
17: ,'YYYY/MM/DD HH24:MI:SS')