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.OZF_ALLOCATION_ENGINE_PVT dependencies on ENI_PROD_DENORM_HRCHY_V

Line 325: ENI_PROD_DENORM_HRCHY_V DENORM

321: AND bsmv.time_id = l_time_id
322: AND bsmv.inventory_item_id IN
323: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
324: FROM MTL_ITEM_CATEGORIES MIC,
325: ENI_PROD_DENORM_HRCHY_V DENORM
326: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
327: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
328: AND DENORM.PARENT_ID = l_category_id
329: MINUS

Line 358: ENI_PROD_DENORM_HRCHY_V DENORM

354: AND bsmv.time_id = l_time_id
355: AND bsmv.inventory_item_id IN
356: (SELECT DISTINCT MIC.INVENTORY_ITEM_ID
357: FROM MTL_ITEM_CATEGORIES MIC,
358: ENI_PROD_DENORM_HRCHY_V DENORM
359: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
360: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
361: AND DENORM.PARENT_ID = l_category_id
362: MINUS

Line 396: ENI_PROD_DENORM_HRCHY_V DENORM,

392: AND prod.inventory_item_id = bsmv.inventory_item_id
393: UNION ALL
394: SELECT MIC.INVENTORY_ITEM_ID
395: FROM MTL_ITEM_CATEGORIES MIC,
396: ENI_PROD_DENORM_HRCHY_V DENORM,
397: AMS_ACT_PRODUCTS prod
398: WHERE
399: prod.level_type_code = 'FAMILY'
400: AND prod.arc_act_product_used_by = 'FUND'

Line 447: ENI_PROD_DENORM_HRCHY_V DENORM,

443: AND p.item_id = bsmv.inventory_item_id
444: UNION ALL
445: SELECT MIC.INVENTORY_ITEM_ID
446: FROM MTL_ITEM_CATEGORIES MIC,
447: ENI_PROD_DENORM_HRCHY_V DENORM,
448: OZF_PRODUCT_ALLOCATIONS p
449: WHERE p.FUND_ID = l_fund_id
450: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
451: AND p.ITEM_ID = DENORM.PARENT_ID

Line 1023: ENI_PROD_DENORM_HRCHY_V DENORM

1019: AND bsmv.time_id = l_time_id
1020: AND bsmv.inventory_item_id IN
1021: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
1022: FROM MTL_ITEM_CATEGORIES MIC,
1023: ENI_PROD_DENORM_HRCHY_V DENORM
1024: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
1025: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
1026: AND DENORM.PARENT_ID = l_category_id
1027: MINUS

Line 1059: ENI_PROD_DENORM_HRCHY_V DENORM,

1055: AND p.item_id = bsmv.inventory_item_id
1056: UNION ALL
1057: SELECT MIC.INVENTORY_ITEM_ID
1058: FROM MTL_ITEM_CATEGORIES MIC,
1059: ENI_PROD_DENORM_HRCHY_V DENORM,
1060: OZF_PRODUCT_ALLOCATIONS p
1061: WHERE p.FUND_ID = l_fund_id
1062: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
1063: AND p.ITEM_ID = DENORM.PARENT_ID

Line 1734: ENI_PROD_DENORM_HRCHY_V DENORM

1730: AND bsmv.time_id = l_time_id
1731: AND bsmv.inventory_item_id IN
1732: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
1733: FROM MTL_ITEM_CATEGORIES MIC,
1734: ENI_PROD_DENORM_HRCHY_V DENORM
1735: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
1736: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
1737: AND DENORM.PARENT_ID = l_category_id
1738: MINUS

Line 1770: ENI_PROD_DENORM_HRCHY_V DENORM,

1766: AND p.item_id = bsmv.inventory_item_id
1767: UNION ALL
1768: SELECT MIC.INVENTORY_ITEM_ID
1769: FROM MTL_ITEM_CATEGORIES MIC,
1770: ENI_PROD_DENORM_HRCHY_V DENORM,
1771: OZF_PRODUCT_ALLOCATIONS p
1772: WHERE p.FUND_ID = l_fund_id
1773: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
1774: AND p.ITEM_ID = DENORM.PARENT_ID

Line 2549: ENI_PROD_DENORM_HRCHY_V DENORM

2545: AND bsmv.time_id = l_time_id
2546: AND bsmv.inventory_item_id IN
2547: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
2548: FROM MTL_ITEM_CATEGORIES MIC,
2549: ENI_PROD_DENORM_HRCHY_V DENORM
2550: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
2551: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
2552: AND DENORM.PARENT_ID = l_category_id
2553: MINUS

Line 2589: ENI_PROD_DENORM_HRCHY_V DENORM,

2585: AND prod.inventory_item_id = bsmv.inventory_item_id
2586: UNION ALL
2587: SELECT MIC.INVENTORY_ITEM_ID
2588: FROM MTL_ITEM_CATEGORIES MIC,
2589: ENI_PROD_DENORM_HRCHY_V DENORM,
2590: AMS_ACT_PRODUCTS prod
2591: WHERE
2592: prod.level_type_code = 'FAMILY'
2593: AND prod.arc_act_product_used_by = 'FUND'

Line 4157: ENI_PROD_DENORM_HRCHY_V DENORM

4153: AND bsmv.time_id = l_time_id
4154: AND bsmv.inventory_item_id IN
4155: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
4156: FROM MTL_ITEM_CATEGORIES MIC,
4157: ENI_PROD_DENORM_HRCHY_V DENORM
4158: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
4159: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4160: AND DENORM.PARENT_ID = l_category_id
4161: MINUS

Line 4599: ENI_PROD_DENORM_HRCHY_V DENORM

4595: AND bsmv.time_id = l_time_id
4596: AND bsmv.inventory_item_id IN
4597: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
4598: FROM MTL_ITEM_CATEGORIES MIC,
4599: ENI_PROD_DENORM_HRCHY_V DENORM
4600: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
4601: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4602: AND DENORM.PARENT_ID = l_category_id
4603: MINUS

Line 5203: ENI_PROD_DENORM_HRCHY_V DENORM

5199: AND bsmv.time_id = l_time_id
5200: AND bsmv.inventory_item_id IN
5201: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
5202: FROM MTL_ITEM_CATEGORIES MIC,
5203: ENI_PROD_DENORM_HRCHY_V DENORM
5204: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
5205: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
5206: AND DENORM.PARENT_ID = l_category_id
5207: MINUS

Line 5241: ENI_PROD_DENORM_HRCHY_V DENORM,

5237: AND p.item_id = bsmv.inventory_item_id
5238: UNION ALL
5239: SELECT MIC.INVENTORY_ITEM_ID
5240: FROM MTL_ITEM_CATEGORIES MIC,
5241: ENI_PROD_DENORM_HRCHY_V DENORM,
5242: OZF_PRODUCT_ALLOCATIONS p
5243: WHERE p.FUND_ID = l_fund_id
5244: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
5245: AND p.ITEM_ID = DENORM.PARENT_ID

Line 6315: ENI_PROD_DENORM_HRCHY_V DENORM

6311: AND bsmv.time_id = l_time_id
6312: AND bsmv.inventory_item_id IN
6313: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
6314: FROM MTL_ITEM_CATEGORIES MIC,
6315: ENI_PROD_DENORM_HRCHY_V DENORM
6316: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
6317: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
6318: AND DENORM.PARENT_ID = l_category_id
6319: MINUS

Line 6353: ENI_PROD_DENORM_HRCHY_V DENORM,

6349: AND p.item_id = bsmv.inventory_item_id
6350: UNION ALL
6351: SELECT MIC.INVENTORY_ITEM_ID
6352: FROM MTL_ITEM_CATEGORIES MIC,
6353: ENI_PROD_DENORM_HRCHY_V DENORM,
6354: OZF_PRODUCT_ALLOCATIONS p
6355: WHERE p.FUND_ID = l_fund_id
6356: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
6357: AND p.ITEM_ID = DENORM.PARENT_ID

Line 9445: ENI_PROD_DENORM_HRCHY_V DENORM

9441: AND bsmv.time_id = l_time_id
9442: AND bsmv.inventory_item_id IN
9443: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
9444: FROM MTL_ITEM_CATEGORIES MIC,
9445: ENI_PROD_DENORM_HRCHY_V DENORM
9446: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
9447: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
9448: AND DENORM.PARENT_ID = l_category_id
9449: MINUS

Line 9483: ENI_PROD_DENORM_HRCHY_V DENORM,

9479: AND p.item_id = bsmv.inventory_item_id
9480: UNION ALL
9481: SELECT MIC.INVENTORY_ITEM_ID
9482: FROM MTL_ITEM_CATEGORIES MIC,
9483: ENI_PROD_DENORM_HRCHY_V DENORM,
9484: OZF_PRODUCT_ALLOCATIONS p
9485: WHERE p.FUND_ID = l_fund_id
9486: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
9487: AND p.ITEM_ID = DENORM.PARENT_ID