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 306: ENI_PROD_DENORM_HRCHY_V DENORM

302: AND bsmv.time_id = l_time_id
303: AND bsmv.inventory_item_id IN
304: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
305: FROM MTL_ITEM_CATEGORIES MIC,
306: ENI_PROD_DENORM_HRCHY_V DENORM
307: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
308: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
309: AND DENORM.PARENT_ID = l_category_id
310: MINUS

Line 339: ENI_PROD_DENORM_HRCHY_V DENORM

335: AND bsmv.time_id = l_time_id
336: AND bsmv.inventory_item_id IN
337: (SELECT DISTINCT MIC.INVENTORY_ITEM_ID
338: FROM MTL_ITEM_CATEGORIES MIC,
339: ENI_PROD_DENORM_HRCHY_V DENORM
340: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
341: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
342: AND DENORM.PARENT_ID = l_category_id
343: MINUS

Line 377: ENI_PROD_DENORM_HRCHY_V DENORM,

373: AND prod.inventory_item_id = bsmv.inventory_item_id
374: UNION ALL
375: SELECT MIC.INVENTORY_ITEM_ID
376: FROM MTL_ITEM_CATEGORIES MIC,
377: ENI_PROD_DENORM_HRCHY_V DENORM,
378: AMS_ACT_PRODUCTS prod
379: WHERE
380: prod.level_type_code = 'FAMILY'
381: AND prod.arc_act_product_used_by = 'FUND'

Line 428: ENI_PROD_DENORM_HRCHY_V DENORM,

424: AND p.item_id = bsmv.inventory_item_id
425: UNION ALL
426: SELECT MIC.INVENTORY_ITEM_ID
427: FROM MTL_ITEM_CATEGORIES MIC,
428: ENI_PROD_DENORM_HRCHY_V DENORM,
429: OZF_PRODUCT_ALLOCATIONS p
430: WHERE p.FUND_ID = l_fund_id
431: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
432: AND p.ITEM_ID = DENORM.PARENT_ID

Line 1004: ENI_PROD_DENORM_HRCHY_V DENORM

1000: AND bsmv.time_id = l_time_id
1001: AND bsmv.inventory_item_id IN
1002: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
1003: FROM MTL_ITEM_CATEGORIES MIC,
1004: ENI_PROD_DENORM_HRCHY_V DENORM
1005: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
1006: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
1007: AND DENORM.PARENT_ID = l_category_id
1008: MINUS

Line 1040: ENI_PROD_DENORM_HRCHY_V DENORM,

1036: AND p.item_id = bsmv.inventory_item_id
1037: UNION ALL
1038: SELECT MIC.INVENTORY_ITEM_ID
1039: FROM MTL_ITEM_CATEGORIES MIC,
1040: ENI_PROD_DENORM_HRCHY_V DENORM,
1041: OZF_PRODUCT_ALLOCATIONS p
1042: WHERE p.FUND_ID = l_fund_id
1043: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
1044: AND p.ITEM_ID = DENORM.PARENT_ID

Line 1713: ENI_PROD_DENORM_HRCHY_V DENORM

1709: AND bsmv.time_id = l_time_id
1710: AND bsmv.inventory_item_id IN
1711: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
1712: FROM MTL_ITEM_CATEGORIES MIC,
1713: ENI_PROD_DENORM_HRCHY_V DENORM
1714: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
1715: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
1716: AND DENORM.PARENT_ID = l_category_id
1717: MINUS

Line 1749: ENI_PROD_DENORM_HRCHY_V DENORM,

1745: AND p.item_id = bsmv.inventory_item_id
1746: UNION ALL
1747: SELECT MIC.INVENTORY_ITEM_ID
1748: FROM MTL_ITEM_CATEGORIES MIC,
1749: ENI_PROD_DENORM_HRCHY_V DENORM,
1750: OZF_PRODUCT_ALLOCATIONS p
1751: WHERE p.FUND_ID = l_fund_id
1752: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
1753: AND p.ITEM_ID = DENORM.PARENT_ID

Line 2526: ENI_PROD_DENORM_HRCHY_V DENORM

2522: AND bsmv.time_id = l_time_id
2523: AND bsmv.inventory_item_id IN
2524: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
2525: FROM MTL_ITEM_CATEGORIES MIC,
2526: ENI_PROD_DENORM_HRCHY_V DENORM
2527: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
2528: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
2529: AND DENORM.PARENT_ID = l_category_id
2530: MINUS

Line 2566: ENI_PROD_DENORM_HRCHY_V DENORM,

2562: AND prod.inventory_item_id = bsmv.inventory_item_id
2563: UNION ALL
2564: SELECT MIC.INVENTORY_ITEM_ID
2565: FROM MTL_ITEM_CATEGORIES MIC,
2566: ENI_PROD_DENORM_HRCHY_V DENORM,
2567: AMS_ACT_PRODUCTS prod
2568: WHERE
2569: prod.level_type_code = 'FAMILY'
2570: AND prod.arc_act_product_used_by = 'FUND'

Line 4132: ENI_PROD_DENORM_HRCHY_V DENORM

4128: AND bsmv.time_id = l_time_id
4129: AND bsmv.inventory_item_id IN
4130: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
4131: FROM MTL_ITEM_CATEGORIES MIC,
4132: ENI_PROD_DENORM_HRCHY_V DENORM
4133: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
4134: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4135: AND DENORM.PARENT_ID = l_category_id
4136: MINUS

Line 4572: ENI_PROD_DENORM_HRCHY_V DENORM

4568: AND bsmv.time_id = l_time_id
4569: AND bsmv.inventory_item_id IN
4570: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
4571: FROM MTL_ITEM_CATEGORIES MIC,
4572: ENI_PROD_DENORM_HRCHY_V DENORM
4573: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
4574: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4575: AND DENORM.PARENT_ID = l_category_id
4576: MINUS

Line 5176: ENI_PROD_DENORM_HRCHY_V DENORM

5172: AND bsmv.time_id = l_time_id
5173: AND bsmv.inventory_item_id IN
5174: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
5175: FROM MTL_ITEM_CATEGORIES MIC,
5176: ENI_PROD_DENORM_HRCHY_V DENORM
5177: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
5178: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
5179: AND DENORM.PARENT_ID = l_category_id
5180: MINUS

Line 5214: ENI_PROD_DENORM_HRCHY_V DENORM,

5210: AND p.item_id = bsmv.inventory_item_id
5211: UNION ALL
5212: SELECT MIC.INVENTORY_ITEM_ID
5213: FROM MTL_ITEM_CATEGORIES MIC,
5214: ENI_PROD_DENORM_HRCHY_V DENORM,
5215: OZF_PRODUCT_ALLOCATIONS p
5216: WHERE p.FUND_ID = l_fund_id
5217: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
5218: AND p.ITEM_ID = DENORM.PARENT_ID

Line 6286: ENI_PROD_DENORM_HRCHY_V DENORM

6282: AND bsmv.time_id = l_time_id
6283: AND bsmv.inventory_item_id IN
6284: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
6285: FROM MTL_ITEM_CATEGORIES MIC,
6286: ENI_PROD_DENORM_HRCHY_V DENORM
6287: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
6288: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
6289: AND DENORM.PARENT_ID = l_category_id
6290: MINUS

Line 6324: ENI_PROD_DENORM_HRCHY_V DENORM,

6320: AND p.item_id = bsmv.inventory_item_id
6321: UNION ALL
6322: SELECT MIC.INVENTORY_ITEM_ID
6323: FROM MTL_ITEM_CATEGORIES MIC,
6324: ENI_PROD_DENORM_HRCHY_V DENORM,
6325: OZF_PRODUCT_ALLOCATIONS p
6326: WHERE p.FUND_ID = l_fund_id
6327: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
6328: AND p.ITEM_ID = DENORM.PARENT_ID

Line 9412: ENI_PROD_DENORM_HRCHY_V DENORM

9408: AND bsmv.time_id = l_time_id
9409: AND bsmv.inventory_item_id IN
9410: ( SELECT DISTINCT MIC.INVENTORY_ITEM_ID
9411: FROM MTL_ITEM_CATEGORIES MIC,
9412: ENI_PROD_DENORM_HRCHY_V DENORM
9413: WHERE MIC.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
9414: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
9415: AND DENORM.PARENT_ID = l_category_id
9416: MINUS

Line 9450: ENI_PROD_DENORM_HRCHY_V DENORM,

9446: AND p.item_id = bsmv.inventory_item_id
9447: UNION ALL
9448: SELECT MIC.INVENTORY_ITEM_ID
9449: FROM MTL_ITEM_CATEGORIES MIC,
9450: ENI_PROD_DENORM_HRCHY_V DENORM,
9451: OZF_PRODUCT_ALLOCATIONS p
9452: WHERE p.FUND_ID = l_fund_id
9453: AND p.ITEM_TYPE = 'PRICING_ATTRIBUTE2'
9454: AND p.ITEM_ID = DENORM.PARENT_ID