eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on HZ_CUST_ACCOUNTS_ALL

Line 2068: , hz_cust_accounts_all hzca

2064: FROM hr_operating_units ou
2065: , hz_cust_acct_sites_all casa
2066: , hz_cust_site_uses_all csua
2067: , hz_parties hzp
2068: , hz_cust_accounts_all hzca
2069: WHERE ou.organization_id = csua.org_id
2070: AND casa.cust_acct_site_id = csua.cust_acct_site_id
2071: AND casa.cust_account_id = hzca.cust_account_id
2072: AND casa.org_id = csua.org_id

Line 2082: , hz_cust_accounts_all caa

2078: CURSOR c_ship_to IS
2079: SELECT 1
2080: FROM hz_cust_acct_sites_all casa
2081: , hz_cust_site_uses_all csua
2082: , hz_cust_accounts_all caa
2083: WHERE casa.cust_acct_site_id = csua.cust_acct_site_id
2084: AND casa.org_id = csua.org_id
2085: AND casa.cust_account_id = caa.cust_account_id
2086: AND csua.site_use_code = 'SHIP_TO'