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_PARTY_SITES

Line 1079: FROM HZ_PARTY_SITES PARTY_SITE, --HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

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

Line 1132: FROM HZ_PARTY_SITES PARTY_SITE, --HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

1128: AND RAA.Customer_Id = P_Customer_Id; */
1129:
1130: SELECT ACCT_SITE.CUST_ACCT_SITE_ID , ACCT_SITE.STATUS
1131: INTO Temp_Address_Id, Temp_Status
1132: FROM HZ_PARTY_SITES PARTY_SITE, --HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1133: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1134: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1135: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1136: --AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID