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_FUNDS_PUB dependencies on AMS_ACT_PRODUCTS

Line 2038: FROM ams_act_products

2034: l_inv_id_exists NUMBER := NULL;
2035:
2036: CURSOR c_act_prod_exists (p_activity_product_id IN NUMBER) IS
2037: SELECT 1
2038: FROM ams_act_products
2039: WHERE activity_product_id = p_activity_product_id;
2040:
2041: CURSOR c_act_prod_used_by_exists (p_prod_used_by IN NUMBER) IS
2042: SELECT 1

Line 2412: FROM ams_act_products

2408:
2409: CURSOR c_prod_elig_details (p_act_prod_id IN NUMBER) IS
2410: SELECT act_product_used_by_id, inventory_item_id, category_id, category_set_id,
2411: primary_product_flag, excluded_flag, object_version_number
2412: FROM ams_act_products
2413: WHERE activity_product_id = p_act_prod_id;
2414:
2415: BEGIN
2416:

Line 2544: FROM ams_act_products

2540: l_object_version NUMBER := NULL;
2541:
2542: CURSOR c_valid_act_prod_id IS
2543: SELECT object_version_number
2544: FROM ams_act_products
2545: WHERE activity_product_id = p_act_product_id;
2546:
2547: BEGIN
2548:

Line 2792: FROM AMS_ACT_PRODUCTS

2788: p_fund_id IN NUMBER,
2789: p_act_product_used_by IN VARCHAR2,
2790: p_level_type_code IN VARCHAR2) IS
2791: SELECT object_version_number
2792: FROM AMS_ACT_PRODUCTS
2793: WHERE inventory_item_id = p_inventory_item_id
2794: AND category_id = p_category_id
2795: AND act_product_used_by_id = p_fund_id
2796: AND arc_act_product_used_by = p_act_product_used_by