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 MTL_ITEM_CATEGORIES

Line 305: FROM MTL_ITEM_CATEGORIES MIC,

301: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 338: FROM MTL_ITEM_CATEGORIES MIC,

334: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 376: FROM MTL_ITEM_CATEGORIES MIC,

372: AND prod.excluded_flag = 'N'
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'

Line 427: FROM MTL_ITEM_CATEGORIES MIC,

423: AND p.item_type = 'PRICING_ATTRIBUTE1'
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'

Line 1003: FROM MTL_ITEM_CATEGORIES MIC,

999: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 1039: FROM MTL_ITEM_CATEGORIES MIC,

1035: AND p.item_type = 'PRICING_ATTRIBUTE1'
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'

Line 1712: FROM MTL_ITEM_CATEGORIES MIC,

1708: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 1748: FROM MTL_ITEM_CATEGORIES MIC,

1744: AND p.item_type = 'PRICING_ATTRIBUTE1'
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'

Line 2525: FROM MTL_ITEM_CATEGORIES MIC,

2521: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 2565: FROM MTL_ITEM_CATEGORIES MIC,

2561: AND prod.excluded_flag = 'N'
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'

Line 4131: FROM MTL_ITEM_CATEGORIES MIC,

4127: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 4571: FROM MTL_ITEM_CATEGORIES MIC,

4567: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 5175: FROM MTL_ITEM_CATEGORIES MIC,

5171: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 5213: FROM MTL_ITEM_CATEGORIES MIC,

5209: AND p.item_type = 'PRICING_ATTRIBUTE1'
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'

Line 6285: FROM MTL_ITEM_CATEGORIES MIC,

6281: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 6323: FROM MTL_ITEM_CATEGORIES MIC,

6319: AND p.item_type = 'PRICING_ATTRIBUTE1'
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'

Line 7912: FROM mtl_item_categories mtl

7908: AND bsmv.ship_to_site_use_id = a.site_use_id
7909: AND bsmv.time_id = l_time_id
7910: AND bsmv.inventory_item_id IN
7911: ( SELECT mtl.inventory_item_id
7912: FROM mtl_item_categories mtl
7913: WHERE mtl.category_id = l_category_id
7914: MINUS
7915: SELECT p.item_id
7916: FROM ozf_product_allocations p

Line 7948: mtl_item_categories mtl

7944: AND p.item_id = bsmv.inventory_item_id
7945: UNION ALL
7946: SELECT mtl.inventory_item_id
7947: FROM ozf_product_allocations p,
7948: mtl_item_categories mtl
7949: WHERE
7950: p.fund_id = l_fund_id
7951: AND p.item_type = 'PRICING_ATTRIBUTE2'
7952: AND p.item_id = mtl.category_id

Line 9411: FROM MTL_ITEM_CATEGORIES MIC,

9407: AND bsmv.ship_to_site_use_id = a.site_use_id
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

Line 9449: FROM MTL_ITEM_CATEGORIES MIC,

9445: AND p.item_type = 'PRICING_ATTRIBUTE1'
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'