APPS.AMS_DMEXTRACT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1087: hz_cust_accounts hca,

1083: MAX(hcp.payment_grace_days) payment_grace_days
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

Line 1128: hz_cust_accounts hca,

1124: MAX(hcp.payment_grace_days) payment_grace_days
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'

Line 1178: hz_cust_accounts hca,

1174: MAX(hcp.payment_grace_days) payment_grace_days
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

Line 1389: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv

1385: 0,--SYSDATE - MAX(hca.account_termination_date),
1386: 0 --SYSDATE - MAX(hca.account_activation_date)
1387: , drv.party_id
1388: -- SYSDATE - MAX(hca.account_suspension_date)
1389: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv
1390: WHERE hca.party_id = drv.party_id
1391: AND hca.status = 'A'
1392: GROUP BY drv.party_id;
1393:

Line 1400: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv, hz_relationships hpr

1396: 0,--SYSDATE - MAX(hca.account_termination_date),
1397: 0 --SYSDATE - MAX(hca.account_activation_date)
1398: , drv.party_id
1399: -- SYSDATE - MAX(hca.account_suspension_date)
1400: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv, hz_relationships hpr
1401: WHERE hca.party_id = hpr.object_id
1402: AND drv.party_id = hpr.party_id
1403: AND hpr.status = 'A'
1404: AND hpr.subject_table_name = 'HZ_PARTIES'

Line 2052: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv

2048: SELECT SYSDATE - MAX(hca.account_established_date),
2049: 0,--SYSDATE - MAX(hca.account_termination_date),
2050: 0 --SYSDATE - MAX(hca.account_activation_date)
2051: ,drv.party_id
2052: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv
2053: WHERE hca.party_id = drv.party_id
2054: AND hca.status = 'A'
2055: group by drv.party_id;
2056: