APPS.AMS_DMSELECTION_PVT dependencies on HZ_CUST_ACCOUNTS

Line 2193: HZ_CUST_ACCOUNTS hc

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,
2193: HZ_CUST_ACCOUNTS hc
2194: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'
2195: and aa.ACT_PRODUCT_USED_BY_ID = p_model_id
2196: and ol.INVENTORY_ITEM_ID IN
2197: (SELECT DISTINCT ic.INVENTORY_ITEM_ID

Line 2471: FROM hz_cust_accounts c, hz_suspension_activity s

2467: UPDATE /*+ index(t AMS_DM_SOURCE_U2) */ ams_dm_source t
2468: SET target_value = (SELECT L_POSITIVE_TARGET_VALUE
2469: FROM dual
2470: WHERE EXISTS (SELECT 1
2471: FROM hz_cust_accounts c, hz_suspension_activity s
2472: WHERE c.party_id = t.party_id
2473: AND s.cust_account_id = c.cust_account_id
2474: AND s.action_type = L_NON_LOYAL_CODE
2475: ))