APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on AMS_ACT_PRODUCTS

Line 1845: FROM ams_act_products

1841: SELECT activity_product_id,
1842: inventory_item_id,
1843: category_id,
1844: level_type_code
1845: FROM ams_act_products
1846: WHERE act_product_used_by_id = l_used_by_id
1847: AND activity_product_id = NVL(p_lline_id, activity_product_id)
1848: AND arc_act_product_used_by = 'OFFR'
1849: AND excluded_flag = 'N'

Line 1856: FROM ams_act_products

1852: CURSOR c_excluded_products(l_used_by_id NUMBER, l_org_id NUMBER) IS
1853: SELECT inventory_item_id,
1854: category_id,
1855: level_type_code
1856: FROM ams_act_products
1857: WHERE act_product_used_by_id = l_used_by_id
1858: AND arc_act_product_used_by = 'PROD'
1859: AND excluded_flag = 'Y'
1860: AND organization_id = l_org_id;

Line 1864: FROM ams_act_products

1860: AND organization_id = l_org_id;
1861:
1862: CURSOR c_no_products(l_used_by_id NUMBER, l_org_id NUMBER) IS
1863: SELECT COUNT(*)
1864: FROM ams_act_products
1865: WHERE act_product_used_by_id = l_used_by_id
1866: AND activity_product_id = NVL(p_lline_id, activity_product_id)
1867: AND arc_act_product_used_by = 'OFFR'
1868: AND excluded_flag = 'N'

Line 1873: FROM ams_act_products

1869: AND organization_id = l_org_id;
1870:
1871: CURSOR c_no_excl_products(l_used_by_id NUMBER, l_org_id NUMBER) IS
1872: SELECT COUNT(*)
1873: FROM ams_act_products
1874: WHERE act_product_used_by_id = l_used_by_id
1875: AND arc_act_product_used_by = 'PROD'
1876: AND excluded_flag = 'Y'
1877: AND organization_id = l_org_id;

Line 2555: FROM ams_act_products

2551: AND (a.end_date_active IS NULL
2552: OR a.end_date_active >= SYSDATE)
2553: UNION
2554: SELECT activity_product_id lline_id
2555: FROM ams_act_products
2556: WHERE act_product_used_by_id = ll_list_header_id
2557: AND arc_act_product_used_by = 'OFFR'
2558: AND excluded_flag = 'N'
2559: UNION