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 420: BOM_PARAMETERS BP,

416: L_PROG_ID,
417: sysdate
418: FROM
419: MTL_SYSTEM_ITEMS MSI,
420: BOM_PARAMETERS BP,
421: CST_ITEM_COSTS CIC,
422: MTL_PARAMETERS MP
423: WHERE MSI.ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
424: ,MSI.ORGANIZATION_ID)

Line 484: BOM_PARAMETERS BP,

480: sysdate
481: FROM
482: MTL_ITEM_CATEGORIES MIC,
483: MTL_SYSTEM_ITEMS MSI,
484: BOM_PARAMETERS BP,
485: MTL_CATEGORIES_KFV MCV,
486: CST_ITEM_COSTS CIC,
487: MTL_PARAMETERS MP
488: WHERE P_ORGANIZATION_ID is not null

Line 546: BOM_PARAMETERS BP,

542: sysdate
543: FROM
544: MTL_ITEM_CATEGORIES MIC,
545: MTL_SYSTEM_ITEMS MSI,
546: BOM_PARAMETERS BP,
547: MTL_CATEGORIES_KFV MCV,
548: CST_ITEM_COSTS CIC,
549: MTL_PARAMETERS MP
550: WHERE P_ORGANIZATION_ID is null

Line 620: BOM_PARAMETERS BP,

616: L_PROG_ID,
617: sysdate
618: FROM
619: MTL_SYSTEM_ITEMS_KFV MSI,
620: BOM_PARAMETERS BP,
621: CST_ITEM_COSTS CIC,
622: MTL_PARAMETERS MP
623: WHERE P_ORGANIZATION_ID is not null
624: AND MSI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 682: BOM_PARAMETERS BP,

678: L_PROG_ID,
679: sysdate
680: FROM
681: MTL_SYSTEM_ITEMS_KFV MSI,
682: BOM_PARAMETERS BP,
683: CST_ITEM_COSTS CIC,
684: MTL_PARAMETERS MP
685: WHERE P_ORGANIZATION_ID is null
686: AND MSI.CONCATENATED_SEGMENTS >= DECODE(P_ITEM_FROM