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.

APPS.GMS_MULTI_FUNDING dependencies on HZ_CUST_SITE_USES

Line 2161: HZ_CUST_SITE_USES SU

2157: ****************/
2158: SELECT su.cust_acct_site_id
2159: INTO St_Bill_To_Address_Id
2160: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
2161: HZ_CUST_SITE_USES SU
2162: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
2163: AND acct_site.cust_account_id = X_Customer_Id
2164: AND Nvl(su.Status, 'A') = 'A'
2165: AND su.Site_Use_Code = 'BILL_TO'

Line 2213: Hz_cust_site_Uses su

2209: ****************/
2210: SELECT su.cust_acct_site_id
2211: INTO St_Ship_To_Address_Id
2212: FROM hz_cust_acct_sites acct_site,
2213: Hz_cust_site_Uses su
2214: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
2215: AND acct_site.cust_account_id = X_Customer_Id
2216: AND Nvl(su.Status, 'A') = 'A'
2217: AND su.Site_Use_Code = 'SHIP_TO'

Line 2258: Hz_cust_site_Uses su

2254: --Shared Service Enhancement : Replaced ra_contacts with HZ Table
2255: Select su.Contact_Id
2256: Into X_Ship_To_Contact_Id
2257: From hz_cust_acct_sites acct_site,
2258: Hz_cust_site_Uses su
2259: Where acct_site.cust_acct_site_id = su.cust_acct_site_id
2260: And acct_site.cust_account_id = X_Customer_Id
2261: And Nvl(su.Status, 'A') = 'A'
2262: And su.Site_Use_Code = 'SHIP_TO'

Line 2298: Hz_cust_site_Uses su

2294: --Shared Service Enhancement :Replaced the RA_Contacts with HZ tables.
2295: Select su.Contact_Id
2296: Into X_Ship_To_Contact_Id
2297: From hz_cust_acct_sites acct_site,
2298: Hz_cust_site_Uses su
2299: Where acct_site.cust_acct_site_id = su.cust_acct_site_id
2300: And acct_site.cust_account_id = X_Customer_Id
2301: And Nvl(su.Status, 'A') = 'A'
2302: And su.Site_Use_Code = 'BILL_TO'