APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on AMS_ACT_PRODUCTS

Line 1868: FROM ams_act_products

1864: SELECT activity_product_id,
1865: inventory_item_id,
1866: category_id,
1867: level_type_code
1868: FROM ams_act_products
1869: WHERE act_product_used_by_id = l_used_by_id
1870: AND activity_product_id = NVL(p_lline_id, activity_product_id)
1871: AND arc_act_product_used_by = 'OFFR'
1872: AND excluded_flag = 'N'

Line 1879: FROM ams_act_products

1875: CURSOR c_excluded_products(l_used_by_id NUMBER, l_org_id NUMBER) IS
1876: SELECT inventory_item_id,
1877: category_id,
1878: level_type_code
1879: FROM ams_act_products
1880: WHERE act_product_used_by_id = l_used_by_id
1881: AND arc_act_product_used_by = 'PROD'
1882: AND excluded_flag = 'Y'
1883: AND organization_id = l_org_id;

Line 1887: FROM ams_act_products

1883: AND organization_id = l_org_id;
1884:
1885: CURSOR c_no_products(l_used_by_id NUMBER, l_org_id NUMBER) IS
1886: SELECT COUNT(*)
1887: FROM ams_act_products
1888: WHERE act_product_used_by_id = l_used_by_id
1889: AND activity_product_id = NVL(p_lline_id, activity_product_id)
1890: AND arc_act_product_used_by = 'OFFR'
1891: AND excluded_flag = 'N'

Line 1896: FROM ams_act_products

1892: AND organization_id = l_org_id;
1893:
1894: CURSOR c_no_excl_products(l_used_by_id NUMBER, l_org_id NUMBER) IS
1895: SELECT COUNT(*)
1896: FROM ams_act_products
1897: WHERE act_product_used_by_id = l_used_by_id
1898: AND arc_act_product_used_by = 'PROD'
1899: AND excluded_flag = 'Y'
1900: AND organization_id = l_org_id;

Line 2612: FROM ams_act_products

2608: AND (a.end_date_active IS NULL
2609: OR a.end_date_active >= SYSDATE)
2610: UNION
2611: SELECT activity_product_id lline_id
2612: FROM ams_act_products
2613: WHERE act_product_used_by_id = ll_list_header_id
2614: AND arc_act_product_used_by = 'OFFR'
2615: AND excluded_flag = 'N'
2616: UNION