APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on BOM_PARAMETERS

Line 34: BOM_PARAMETERS BP

30: AND not exists (
31: SELECT
32: 'x'
33: FROM
34: BOM_PARAMETERS BP
35: WHERE CSLLC.ORGANIZATION_ID = BP.ORGANIZATION_ID );
36: CURSOR NO_ALT_ORGS(I_SNAPSHOT_DESIGNATOR IN VARCHAR2) IS
37: SELECT
38: DISTINCT

Line 428: BOM_PARAMETERS BP,

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
432: ,MSI.ORGANIZATION_ID)

Line 492: BOM_PARAMETERS BP,

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
496: WHERE LP_ORGANIZATION_ID is not null

Line 554: BOM_PARAMETERS BP,

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
558: WHERE LP_ORGANIZATION_ID is null

Line 628: BOM_PARAMETERS BP,

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
632: AND MSI.ORGANIZATION_ID = LP_ORGANIZATION_ID

Line 690: BOM_PARAMETERS BP,

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
694: AND MSI.CONCATENATED_SEGMENTS >= DECODE(P_ITEM_FROM