APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_ACT_PRODUCTS

Line 4480: select inventory_item_id, ams_act_products.category_id, organization_id

4476: where party_id = p_party_id;
4477:
4478: -- anchaudh 17th Mar'05 : modified the cursor to pull up only purchasable products for bug#3607972.
4479: cursor c_assoc_products_csr(p_schedule_id NUMBER) is
4480: select inventory_item_id, ams_act_products.category_id, organization_id
4481: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat
4482: where arc_act_product_used_by = 'CSCH'
4483: and act_product_used_by_id = p_schedule_id
4484: and ams_act_products.category_id = cat.category_id(+)

Line 4481: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat

4477:
4478: -- anchaudh 17th Mar'05 : modified the cursor to pull up only purchasable products for bug#3607972.
4479: cursor c_assoc_products_csr(p_schedule_id NUMBER) is
4480: select inventory_item_id, ams_act_products.category_id, organization_id
4481: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat
4482: where arc_act_product_used_by = 'CSCH'
4483: and act_product_used_by_id = p_schedule_id
4484: and ams_act_products.category_id = cat.category_id(+)
4485: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';

Line 4484: and ams_act_products.category_id = cat.category_id(+)

4480: select inventory_item_id, ams_act_products.category_id, organization_id
4481: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat
4482: where arc_act_product_used_by = 'CSCH'
4483: and act_product_used_by_id = p_schedule_id
4484: and ams_act_products.category_id = cat.category_id(+)
4485: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';
4486:
4487: cursor c_schedule_details_csr(p_schedule_id NUMBER) is
4488: select a.source_code, a.sales_methodology_id, b.source_code_id