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 AMS_ACT_PRODUCTS

Line 312: FROM ams_act_products a

308: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
309: AND DENORM.PARENT_ID = l_category_id
310: MINUS
311: SELECT a.inventory_item_id
312: FROM ams_act_products a
313: WHERE act_product_used_by_id = l_fund_id
314: AND arc_act_product_used_by = 'FUND'
315: AND level_type_code = 'PRODUCT'
316: AND excluded_flag IN ('Y', 'N')

Line 367: FROM ams_act_products prod

363: AND bsmv.time_id = l_time_id
364: AND NOT EXISTS
365: (
366: ( SELECT prod.inventory_item_id
367: FROM ams_act_products prod
368: WHERE
369: prod.level_type_code = 'PRODUCT'
370: AND prod.arc_act_product_used_by = 'FUND'
371: AND prod.act_product_used_by_id = l_fund_id

Line 378: AMS_ACT_PRODUCTS prod

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'
382: AND prod.act_product_used_by_id = l_fund_id

Line 391: FROM ams_act_products prod

387: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
388: )
389: MINUS
390: SELECT prod.inventory_item_id
391: FROM ams_act_products prod
392: where
393: prod.level_type_code = 'PRODUCT'
394: AND prod.arc_act_product_used_by = 'FUND'
395: AND prod.act_product_used_by_id = l_fund_id

Line 439: FROM ams_act_products prod

435: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
436: )
437: MINUS
438: SELECT prod.inventory_item_id
439: FROM ams_act_products prod
440: where
441: prod.level_type_code = 'PRODUCT'
442: AND prod.arc_act_product_used_by = 'FUND'
443: AND prod.act_product_used_by_id = l_fund_id

Line 1051: FROM ams_act_products prod

1047: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
1048: )
1049: MINUS
1050: SELECT prod.inventory_item_id
1051: FROM ams_act_products prod
1052: where
1053: prod.level_type_code = 'PRODUCT'
1054: AND prod.arc_act_product_used_by = 'FUND'
1055: AND prod.act_product_used_by_id = l_fund_id

Line 1760: FROM ams_act_products prod

1756: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
1757: )
1758: MINUS
1759: SELECT prod.inventory_item_id
1760: FROM ams_act_products prod
1761: where
1762: prod.level_type_code = 'PRODUCT'
1763: AND prod.arc_act_product_used_by = 'FUND'
1764: AND prod.act_product_used_by_id = l_fund_id

Line 2451: ams_act_products

2447: CURSOR product_elig_csr (l_fund_id NUMBER) IS
2448: SELECT
2449: inventory_item_id
2450: FROM
2451: ams_act_products
2452: WHERE
2453: act_product_used_by_id = l_fund_id
2454: AND arc_act_product_used_by = 'FUND'
2455: AND level_type_code = 'PRODUCT'

Line 2462: ams_act_products

2458: CURSOR category_elig_csr (l_fund_id NUMBER) IS
2459: SELECT
2460: category_id
2461: FROM
2462: ams_act_products
2463: WHERE
2464: act_product_used_by_id = l_fund_id
2465: AND arc_act_product_used_by = 'FUND'
2466: AND level_type_code = 'FAMILY'

Line 2474: ams_act_products

2470: CURSOR excluded_product_elig_csr (l_fund_id NUMBER) IS
2471: SELECT
2472: inventory_item_id
2473: FROM
2474: ams_act_products
2475: WHERE
2476: act_product_used_by_id = l_fund_id
2477: AND arc_act_product_used_by = 'FUND'
2478: AND level_type_code = 'PRODUCT'

Line 2485: ams_act_products

2481: CURSOR excluded_category_elig_csr (l_fund_id NUMBER) IS
2482: SELECT
2483: category_id
2484: FROM
2485: ams_act_products
2486: WHERE
2487: act_product_used_by_id = l_fund_id
2488: AND arc_act_product_used_by = 'FUND'
2489: AND level_type_code = 'FAMILY'

Line 2532: FROM ams_act_products a

2528: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
2529: AND DENORM.PARENT_ID = l_category_id
2530: MINUS
2531: SELECT a.inventory_item_id
2532: FROM ams_act_products a
2533: WHERE act_product_used_by_id = l_fund_id
2534: AND arc_act_product_used_by = 'FUND'
2535: AND level_type_code = 'PRODUCT'
2536: AND excluded_flag IN ('Y', 'N')

Line 2556: FROM ams_act_products prod

2552: AND bsmv.time_id = l_time_id
2553: AND NOT EXISTS
2554: (
2555: ( SELECT prod.inventory_item_id
2556: FROM ams_act_products prod
2557: WHERE
2558: prod.level_type_code = 'PRODUCT'
2559: AND prod.arc_act_product_used_by = 'FUND'
2560: AND prod.act_product_used_by_id = l_fund_id

Line 2567: AMS_ACT_PRODUCTS prod

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'
2571: AND prod.act_product_used_by_id = l_fund_id

Line 2580: FROM ams_act_products prod

2576: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
2577: )
2578: MINUS
2579: SELECT prod.inventory_item_id
2580: FROM ams_act_products prod
2581: where
2582: prod.level_type_code = 'PRODUCT'
2583: AND prod.arc_act_product_used_by = 'FUND'
2584: AND prod.act_product_used_by_id = l_fund_id

Line 4138: FROM ams_act_products a

4134: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4135: AND DENORM.PARENT_ID = l_category_id
4136: MINUS
4137: SELECT a.inventory_item_id
4138: FROM ams_act_products a
4139: WHERE act_product_used_by_id = l_fund_id
4140: AND arc_act_product_used_by = 'FUND'
4141: AND level_type_code = 'PRODUCT'
4142: AND excluded_flag IN ('Y', 'N')

Line 4578: FROM ams_act_products a

4574: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4575: AND DENORM.PARENT_ID = l_category_id
4576: MINUS
4577: SELECT a.inventory_item_id
4578: FROM ams_act_products a
4579: WHERE act_product_used_by_id = l_fund_id
4580: AND arc_act_product_used_by = 'FUND'
4581: AND level_type_code = 'PRODUCT'
4582: AND excluded_flag IN ('Y', 'N')

Line 5225: FROM ams_act_products prod

5221: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
5222: )
5223: MINUS
5224: SELECT prod.inventory_item_id
5225: FROM ams_act_products prod
5226: where
5227: prod.level_type_code = 'PRODUCT'
5228: AND prod.arc_act_product_used_by = 'FUND'
5229: AND prod.act_product_used_by_id = l_fund_id

Line 6335: FROM ams_act_products prod

6331: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
6332: )
6333: MINUS
6334: SELECT prod.inventory_item_id
6335: FROM ams_act_products prod
6336: where
6337: prod.level_type_code = 'PRODUCT'
6338: AND prod.arc_act_product_used_by = 'FUND'
6339: AND prod.act_product_used_by_id = l_fund_id

Line 7957: FROM ams_act_products prod

7953: AND mtl.inventory_item_id = bsmv.inventory_item_id
7954: )
7955: MINUS
7956: SELECT prod.inventory_item_id
7957: FROM ams_act_products prod
7958: where
7959: prod.level_type_code = 'PRODUCT'
7960: AND prod.arc_act_product_used_by = 'FUND'
7961: AND prod.act_product_used_by_id = l_fund_id

Line 9461: FROM ams_act_products prod

9457: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
9458: )
9459: MINUS
9460: SELECT prod.inventory_item_id
9461: FROM ams_act_products prod
9462: where
9463: prod.level_type_code = 'PRODUCT'
9464: AND prod.arc_act_product_used_by = 'FUND'
9465: AND prod.act_product_used_by_id = l_fund_id