APPS.AMS_DMSELECTION_PVT dependencies on AMS_ACT_PRODUCTS

Line 2151: FROM AMS_ACT_PRODUCTS aa, OE_ORDER_HEADERS_ALL oh, OE_ORDER_LINES_ALL ol,

2147: UPDATE ams_dm_target_stg_gt t
2148: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2149: FROM dual
2150: WHERE EXISTS (SELECT 1
2151: FROM AMS_ACT_PRODUCTS aa, OE_ORDER_HEADERS_ALL oh, OE_ORDER_LINES_ALL ol,
2152: hz_cust_account_roles hcr, hz_relationships hpr
2153: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'
2154: and aa.ACT_PRODUCT_USED_BY_ID = p_model_id
2155: and ol.INVENTORY_ITEM_ID IN

Line 2188: FROM AMS_ACT_PRODUCTS aa,

2184: UPDATE ams_dm_target_stg_gt t
2185: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2186: FROM dual
2187: WHERE EXISTS (SELECT 1
2188: FROM AMS_ACT_PRODUCTS aa,
2189: OE_ORDER_HEADERS_ALL oh,
2190: OE_ORDER_LINES_ALL ol,
2191: --hz_cust_site_uses_all hcsu,
2192: --hz_cust_acct_sites_all hcs,

Line 3842: FROM ams_act_products a, mtl_system_items_kfv b

3838: L_API_NAME VARCHAR2(60) := 'Validate Product Affinity Selection Status';
3839:
3840: CURSOR c_cats_for_model (p_model_id IN NUMBER) IS
3841: SELECT a.category_id, a.inventory_item_id, a.organization_id, a.category_set_id, b.padded_concatenated_segments
3842: FROM ams_act_products a, mtl_system_items_kfv b
3843: WHERE a.ARC_ACT_PRODUCT_USED_BY = 'MODL'
3844: AND a.ACT_PRODUCT_USED_BY_ID = p_model_id
3845: AND a.inventory_item_id = b.inventory_item_id(+)
3846: AND a.organization_id = b.organization_id(+)