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 429: CST_ITEM_COSTS CIC,

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

Line 444: CST_ITEM_COSTS CIC2

440: AND not exists (
441: SELECT
442: 'X'
443: FROM
444: CST_ITEM_COSTS CIC2
445: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
446: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
447: AND CIC2.COST_TYPE_ID = LP_COST_TYPE_ID ) )
448: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 453: CST_ITEM_COSTS CIC3

449: AND not exists (
450: SELECT
451: 'X'
452: FROM
453: CST_ITEM_COSTS CIC3
454: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
455: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
456: AND CIC3.COST_TYPE_ID IN ( LP_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
457: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 494: CST_ITEM_COSTS CIC,

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
497: AND MIC.ORGANIZATION_ID = LP_ORGANIZATION_ID
498: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID

Line 520: CST_ITEM_COSTS CIC2

516: AND not exists (
517: SELECT
518: 'X'
519: FROM
520: CST_ITEM_COSTS CIC2
521: WHERE CIC2.ORGANIZATION_ID = LP_ORGANIZATION_ID
522: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
523: AND CIC2.COST_TYPE_ID = LP_COST_TYPE_ID ) )
524: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 529: CST_ITEM_COSTS CIC3

525: AND not exists (
526: SELECT
527: 'X'
528: FROM
529: CST_ITEM_COSTS CIC3
530: WHERE CIC3.ORGANIZATION_ID = LP_ORGANIZATION_ID
531: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
532: AND CIC3.COST_TYPE_ID IN ( LP_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
533: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 556: CST_ITEM_COSTS CIC,

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

Line 581: CST_ITEM_COSTS CIC2

577: AND not exists (
578: SELECT
579: 'X'
580: FROM
581: CST_ITEM_COSTS CIC2
582: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
583: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
584: AND CIC2.COST_TYPE_ID = LP_COST_TYPE_ID ) )
585: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 590: CST_ITEM_COSTS CIC3

586: AND not exists (
587: SELECT
588: 'X'
589: FROM
590: CST_ITEM_COSTS CIC3
591: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
592: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
593: AND CIC3.COST_TYPE_ID IN ( LP_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
594: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 629: CST_ITEM_COSTS CIC,

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

Line 651: CST_ITEM_COSTS CIC2

647: AND not exists (
648: SELECT
649: 'X'
650: FROM
651: CST_ITEM_COSTS CIC2
652: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
653: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
654: AND CIC2.COST_TYPE_ID = LP_COST_TYPE_ID ) )
655: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 660: CST_ITEM_COSTS CIC3

656: AND not exists (
657: SELECT
658: 'X'
659: FROM
660: CST_ITEM_COSTS CIC3
661: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
662: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
663: AND CIC3.COST_TYPE_ID IN ( LP_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
664: AND CIC.BASED_ON_ROLLUP_FLAG = 1

Line 691: CST_ITEM_COSTS CIC,

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

Line 712: CST_ITEM_COSTS CIC2

708: AND not exists (
709: SELECT
710: 'X'
711: FROM
712: CST_ITEM_COSTS CIC2
713: WHERE CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
714: AND CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
715: AND CIC2.COST_TYPE_ID = LP_COST_TYPE_ID ) )
716: OR ( CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Line 721: CST_ITEM_COSTS CIC3

717: AND not exists (
718: SELECT
719: 'X'
720: FROM
721: CST_ITEM_COSTS CIC3
722: WHERE CIC3.ORGANIZATION_ID = CIC.ORGANIZATION_ID
723: AND CIC3.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
724: AND CIC3.COST_TYPE_ID IN ( LP_COST_TYPE_ID , P_DEFAULT_COST_TYPE_ID ) ) ) )
725: AND CIC.BASED_ON_ROLLUP_FLAG = 1