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 331: FROM ams_act_products a

327: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
328: AND DENORM.PARENT_ID = l_category_id
329: MINUS
330: SELECT a.inventory_item_id
331: FROM ams_act_products a
332: WHERE act_product_used_by_id = l_fund_id
333: AND arc_act_product_used_by = 'FUND'
334: AND level_type_code = 'PRODUCT'
335: AND excluded_flag IN ('Y', 'N')

Line 386: FROM ams_act_products prod

382: AND bsmv.time_id = l_time_id
383: AND NOT EXISTS
384: (
385: ( SELECT prod.inventory_item_id
386: FROM ams_act_products prod
387: WHERE
388: prod.level_type_code = 'PRODUCT'
389: AND prod.arc_act_product_used_by = 'FUND'
390: AND prod.act_product_used_by_id = l_fund_id

Line 397: AMS_ACT_PRODUCTS prod

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

Line 410: FROM ams_act_products prod

406: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
407: )
408: MINUS
409: SELECT prod.inventory_item_id
410: FROM ams_act_products prod
411: where
412: prod.level_type_code = 'PRODUCT'
413: AND prod.arc_act_product_used_by = 'FUND'
414: AND prod.act_product_used_by_id = l_fund_id

Line 458: FROM ams_act_products prod

454: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
455: )
456: MINUS
457: SELECT prod.inventory_item_id
458: FROM ams_act_products prod
459: where
460: prod.level_type_code = 'PRODUCT'
461: AND prod.arc_act_product_used_by = 'FUND'
462: AND prod.act_product_used_by_id = l_fund_id

Line 1070: FROM ams_act_products prod

1066: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
1067: )
1068: MINUS
1069: SELECT prod.inventory_item_id
1070: FROM ams_act_products prod
1071: where
1072: prod.level_type_code = 'PRODUCT'
1073: AND prod.arc_act_product_used_by = 'FUND'
1074: AND prod.act_product_used_by_id = l_fund_id

Line 1781: FROM ams_act_products prod

1777: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
1778: )
1779: MINUS
1780: SELECT prod.inventory_item_id
1781: FROM ams_act_products prod
1782: where
1783: prod.level_type_code = 'PRODUCT'
1784: AND prod.arc_act_product_used_by = 'FUND'
1785: AND prod.act_product_used_by_id = l_fund_id

Line 2474: ams_act_products

2470: CURSOR 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 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 2497: ams_act_products

2493: CURSOR excluded_product_elig_csr (l_fund_id NUMBER) IS
2494: SELECT
2495: inventory_item_id
2496: FROM
2497: ams_act_products
2498: WHERE
2499: act_product_used_by_id = l_fund_id
2500: AND arc_act_product_used_by = 'FUND'
2501: AND level_type_code = 'PRODUCT'

Line 2508: ams_act_products

2504: CURSOR excluded_category_elig_csr (l_fund_id NUMBER) IS
2505: SELECT
2506: category_id
2507: FROM
2508: ams_act_products
2509: WHERE
2510: act_product_used_by_id = l_fund_id
2511: AND arc_act_product_used_by = 'FUND'
2512: AND level_type_code = 'FAMILY'

Line 2555: FROM ams_act_products a

2551: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
2552: AND DENORM.PARENT_ID = l_category_id
2553: MINUS
2554: SELECT a.inventory_item_id
2555: FROM ams_act_products a
2556: WHERE act_product_used_by_id = l_fund_id
2557: AND arc_act_product_used_by = 'FUND'
2558: AND level_type_code = 'PRODUCT'
2559: AND excluded_flag IN ('Y', 'N')

Line 2579: FROM ams_act_products prod

2575: AND bsmv.time_id = l_time_id
2576: AND NOT EXISTS
2577: (
2578: ( SELECT prod.inventory_item_id
2579: FROM ams_act_products prod
2580: WHERE
2581: prod.level_type_code = 'PRODUCT'
2582: AND prod.arc_act_product_used_by = 'FUND'
2583: AND prod.act_product_used_by_id = l_fund_id

Line 2590: AMS_ACT_PRODUCTS prod

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

Line 2603: FROM ams_act_products prod

2599: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
2600: )
2601: MINUS
2602: SELECT prod.inventory_item_id
2603: FROM ams_act_products prod
2604: where
2605: prod.level_type_code = 'PRODUCT'
2606: AND prod.arc_act_product_used_by = 'FUND'
2607: AND prod.act_product_used_by_id = l_fund_id

Line 4163: FROM ams_act_products a

4159: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4160: AND DENORM.PARENT_ID = l_category_id
4161: MINUS
4162: SELECT a.inventory_item_id
4163: FROM ams_act_products a
4164: WHERE act_product_used_by_id = l_fund_id
4165: AND arc_act_product_used_by = 'FUND'
4166: AND level_type_code = 'PRODUCT'
4167: AND excluded_flag IN ('Y', 'N')

Line 4605: FROM ams_act_products a

4601: AND MIC.CATEGORY_ID = DENORM.CHILD_ID
4602: AND DENORM.PARENT_ID = l_category_id
4603: MINUS
4604: SELECT a.inventory_item_id
4605: FROM ams_act_products a
4606: WHERE act_product_used_by_id = l_fund_id
4607: AND arc_act_product_used_by = 'FUND'
4608: AND level_type_code = 'PRODUCT'
4609: AND excluded_flag IN ('Y', 'N')

Line 5252: FROM ams_act_products prod

5248: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
5249: )
5250: MINUS
5251: SELECT prod.inventory_item_id
5252: FROM ams_act_products prod
5253: where
5254: prod.level_type_code = 'PRODUCT'
5255: AND prod.arc_act_product_used_by = 'FUND'
5256: AND prod.act_product_used_by_id = l_fund_id

Line 6364: FROM ams_act_products prod

6360: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
6361: )
6362: MINUS
6363: SELECT prod.inventory_item_id
6364: FROM ams_act_products prod
6365: where
6366: prod.level_type_code = 'PRODUCT'
6367: AND prod.arc_act_product_used_by = 'FUND'
6368: AND prod.act_product_used_by_id = l_fund_id

Line 7988: FROM ams_act_products prod

7984: AND mtl.inventory_item_id = bsmv.inventory_item_id
7985: )
7986: MINUS
7987: SELECT prod.inventory_item_id
7988: FROM ams_act_products prod
7989: where
7990: prod.level_type_code = 'PRODUCT'
7991: AND prod.arc_act_product_used_by = 'FUND'
7992: AND prod.act_product_used_by_id = l_fund_id

Line 9494: FROM ams_act_products prod

9490: AND MIC.INVENTORY_ITEM_ID = bsmv.inventory_item_id
9491: )
9492: MINUS
9493: SELECT prod.inventory_item_id
9494: FROM ams_act_products prod
9495: where
9496: prod.level_type_code = 'PRODUCT'
9497: AND prod.arc_act_product_used_by = 'FUND'
9498: AND prod.act_product_used_by_id = l_fund_id