eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on CST_ITEM_COSTS

Line 421: CST_ITEM_COSTS CIC,

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)
425: AND MSI.INVENTORY_ITEM_ID = P_ITEM_ID

Line 436: CST_ITEM_COSTS CIC2

432: AND not exists (
433: SELECT
434: 'X'
435: FROM
436: CST_ITEM_COSTS CIC2
437: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
438: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
439: AND CIC2.COST_TYPE_ID = P_COST_TYPE_ID ) )
440: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 445: CST_ITEM_COSTS CIC3

441: AND not exists (
442: SELECT
443: 'X'
444: FROM
445: CST_ITEM_COSTS CIC3
446: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
447: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
448: AND CIC3.COST_TYPE_ID IN ( P_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
449: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 486: CST_ITEM_COSTS CIC,

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
489: AND MIC.ORGANIZATION_ID = P_ORGANIZATION_ID
490: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID

Line 512: CST_ITEM_COSTS CIC2

508: AND not exists (
509: SELECT
510: 'X'
511: FROM
512: CST_ITEM_COSTS CIC2
513: WHERE CIC2.ORGANIZATION_ID = P_ORGANIZATION_ID
514: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
515: AND CIC2.COST_TYPE_ID = P_COST_TYPE_ID ) )
516: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 521: CST_ITEM_COSTS CIC3

517: AND not exists (
518: SELECT
519: 'X'
520: FROM
521: CST_ITEM_COSTS CIC3
522: WHERE CIC3.ORGANIZATION_ID = P_ORGANIZATION_ID
523: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
524: AND CIC3.COST_TYPE_ID IN ( P_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
525: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 548: CST_ITEM_COSTS CIC,

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
551: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID
552: AND MIC.CATEGORY_ID = MCV.CATEGORY_ID

Line 573: CST_ITEM_COSTS CIC2

569: AND not exists (
570: SELECT
571: 'X'
572: FROM
573: CST_ITEM_COSTS CIC2
574: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
575: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
576: AND CIC2.COST_TYPE_ID = P_COST_TYPE_ID ) )
577: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 582: CST_ITEM_COSTS CIC3

578: AND not exists (
579: SELECT
580: 'X'
581: FROM
582: CST_ITEM_COSTS CIC3
583: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
584: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
585: AND CIC3.COST_TYPE_ID IN ( P_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
586: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 621: CST_ITEM_COSTS CIC,

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

Line 643: CST_ITEM_COSTS CIC2

639: AND not exists (
640: SELECT
641: 'X'
642: FROM
643: CST_ITEM_COSTS CIC2
644: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
645: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
646: AND CIC2.COST_TYPE_ID = P_COST_TYPE_ID ) )
647: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 652: CST_ITEM_COSTS CIC3

648: AND not exists (
649: SELECT
650: 'X'
651: FROM
652: CST_ITEM_COSTS CIC3
653: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
654: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
655: AND CIC3.COST_TYPE_ID IN ( P_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
656: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 683: CST_ITEM_COSTS CIC,

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
687: ,NULL

Line 704: CST_ITEM_COSTS CIC2

700: AND not exists (
701: SELECT
702: 'X'
703: FROM
704: CST_ITEM_COSTS CIC2
705: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
706: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
707: AND CIC2.COST_TYPE_ID = P_COST_TYPE_ID ) )
708: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 713: CST_ITEM_COSTS CIC3

709: AND not exists (
710: SELECT
711: 'X'
712: FROM
713: CST_ITEM_COSTS CIC3
714: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
715: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
716: AND CIC3.COST_TYPE_ID IN ( P_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
717: AND CIC.BASED_ON_ROLLUP_FLAG = 1