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 324: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 357: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 395: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 446: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 1022: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 1058: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 1733: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 1769: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 2548: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 2588: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 4156: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 4598: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 5202: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 5240: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 6314: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 6352: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 7943: FROM mtl_item_categories mtl

7939: AND bsmv.ship_to_site_use_id = a.site_use_id
7940: AND bsmv.time_id = l_time_id
7941: AND bsmv.inventory_item_id IN
7942: ( SELECT mtl.inventory_item_id
7943: FROM mtl_item_categories mtl
7944: WHERE mtl.category_id = l_category_id
7945: MINUS
7946: SELECT p.item_id
7947: FROM ozf_product_allocations p

Line 7979: mtl_item_categories mtl

7975: AND p.item_id = bsmv.inventory_item_id
7976: UNION ALL
7977: SELECT mtl.inventory_item_id
7978: FROM ozf_product_allocations p,
7979: mtl_item_categories mtl
7980: WHERE
7981: p.fund_id = l_fund_id
7982: AND p.item_type = 'PRICING_ATTRIBUTE2'
7983: AND p.item_id = mtl.category_id

Line 9444: FROM MTL_ITEM_CATEGORIES MIC,

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

Line 9482: FROM MTL_ITEM_CATEGORIES MIC,

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