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.INVCIINT dependencies on HZ_LOCATIONS

Line 1079: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1075:
1076: SELECT ACCT_SITE.CUST_ACCT_SITE_ID , ACCT_SITE.STATUS
1077: INTO Temp_Address_Id, Temp_Status
1078: FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1079: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1080: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = P_Address_Id
1081: AND ACCT_SITE.CUST_ACCOUNT_ID = P_Customer_Id
1082: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1083: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1132: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1128:
1129: SELECT ACCT_SITE.CUST_ACCT_SITE_ID , ACCT_SITE.STATUS
1130: INTO Temp_Address_Id, Temp_Status
1131: FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1132: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1133: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1134: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1135: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
1136: AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)