APPS.AMS_DMEXTRACT_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1088: hz_customer_profiles hcp

1084: FROM
1085: -- ams_dm_drv_stg drv,
1086: ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Tables
1087: hz_cust_accounts hca,
1088: hz_customer_profiles hcp
1089: WHERE drv.party_id = hca.party_id(+)
1090: AND hca.status(+) = 'A'
1091: AND hcp.cust_account_id(+) = hca.cust_account_id
1092: AND hcp.status(+) = 'A'

Line 1129: hz_customer_profiles hcp,

1125: FROM
1126: -- ams_dm_drv_stg drv,
1127: ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Tables
1128: hz_cust_accounts hca,
1129: hz_customer_profiles hcp,
1130: hz_relationships hpr
1131: WHERE drv.party_id = hpr.party_id
1132: AND hpr.status = 'A'
1133: AND hpr.subject_table_name = 'HZ_PARTIES'

Line 1179: hz_customer_profiles hcp

1175: FROM
1176: -- ams_dm_drv_stg drv,
1177: ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Table
1178: hz_cust_accounts hca,
1179: hz_customer_profiles hcp
1180: WHERE hcp.cust_account_id(+) = hca.cust_account_id
1181: AND hcp.status(+) = 'A'
1182: AND drv.party_id = hca.party_id
1183: AND hca.status = 'A'