APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_ACT_PRODUCTS

Line 4450: select inventory_item_id, ams_act_products.category_id, organization_id

4446: where party_id = p_party_id;
4447:
4448: -- anchaudh 17th Mar'05 : modified the cursor to pull up only purchasable products for bug#3607972.
4449: cursor c_assoc_products_csr(p_schedule_id NUMBER) is
4450: select inventory_item_id, ams_act_products.category_id, organization_id
4451: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat
4452: where arc_act_product_used_by = 'CSCH'
4453: and act_product_used_by_id = p_schedule_id
4454: and ams_act_products.category_id = cat.category_id(+)

Line 4451: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat

4447:
4448: -- anchaudh 17th Mar'05 : modified the cursor to pull up only purchasable products for bug#3607972.
4449: cursor c_assoc_products_csr(p_schedule_id NUMBER) is
4450: select inventory_item_id, ams_act_products.category_id, organization_id
4451: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat
4452: where arc_act_product_used_by = 'CSCH'
4453: and act_product_used_by_id = p_schedule_id
4454: and ams_act_products.category_id = cat.category_id(+)
4455: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';

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

4450: select inventory_item_id, ams_act_products.category_id, organization_id
4451: from ams_act_products,ENI_PROD_DEN_HRCHY_PARENTS_V cat
4452: where arc_act_product_used_by = 'CSCH'
4453: and act_product_used_by_id = p_schedule_id
4454: and ams_act_products.category_id = cat.category_id(+)
4455: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';
4456:
4457: cursor c_schedule_details_csr(p_schedule_id NUMBER) is
4458: select a.source_code, a.sales_methodology_id, b.source_code_id