DBA Data[Home] [Help]

APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 362: MTL_SYSTEM_ITEMS_KFV MSIV

358: ,1
359: ,2000)
360: INTO P_ITEM_NAME
361: FROM
362: MTL_SYSTEM_ITEMS_KFV MSIV
363: WHERE MSIV.INVENTORY_ITEM_ID = P_ITEM_ID
364: AND MSIV.ORGANIZATION_ID = NVL(LP_ORGANIZATION_ID
365: ,lp_default_org_id);
366: END IF;

Line 427: MTL_SYSTEM_ITEMS MSI,

423: L_PROG_APPL_ID,
424: L_PROG_ID,
425: sysdate
426: FROM
427: MTL_SYSTEM_ITEMS MSI,
428: BOM_PARAMETERS BP,
429: CST_ITEM_COSTS CIC,
430: MTL_PARAMETERS MP
431: WHERE MSI.ORGANIZATION_ID = NVL(LP_ORGANIZATION_ID

Line 491: MTL_SYSTEM_ITEMS MSI,

487: L_PROG_ID,
488: sysdate
489: FROM
490: MTL_ITEM_CATEGORIES MIC,
491: MTL_SYSTEM_ITEMS MSI,
492: BOM_PARAMETERS BP,
493: MTL_CATEGORIES_KFV MCV,
494: CST_ITEM_COSTS CIC,
495: MTL_PARAMETERS MP

Line 553: MTL_SYSTEM_ITEMS MSI,

549: L_PROG_ID,
550: sysdate
551: FROM
552: MTL_ITEM_CATEGORIES MIC,
553: MTL_SYSTEM_ITEMS MSI,
554: BOM_PARAMETERS BP,
555: MTL_CATEGORIES_KFV MCV,
556: CST_ITEM_COSTS CIC,
557: MTL_PARAMETERS MP

Line 627: MTL_SYSTEM_ITEMS_KFV MSI,

623: L_PROG_APPL_ID,
624: L_PROG_ID,
625: sysdate
626: FROM
627: MTL_SYSTEM_ITEMS_KFV MSI,
628: BOM_PARAMETERS BP,
629: CST_ITEM_COSTS CIC,
630: MTL_PARAMETERS MP
631: WHERE LP_ORGANIZATION_ID is not null

Line 689: MTL_SYSTEM_ITEMS_KFV MSI,

685: L_PROG_APPL_ID,
686: L_PROG_ID,
687: sysdate
688: FROM
689: MTL_SYSTEM_ITEMS_KFV MSI,
690: BOM_PARAMETERS BP,
691: CST_ITEM_COSTS CIC,
692: MTL_PARAMETERS MP
693: WHERE LP_ORGANIZATION_ID is null