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.CN_ADJUSTMENTS_PKG dependencies on HZ_PARTY_SITES

Line 1382: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

1378: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1379: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) rac,
1380: (SELECT ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ,
1381: LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE ,
1382: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1383: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1384: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1385: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1386: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID

Line 1390: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

1386: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
1387: AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)) raba,
1388: (SELECT ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ,
1389: LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE ,
1390: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1391: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1392: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1393: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1394: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID

Line 1477: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

1473: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1474: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) rac,
1475: (SELECT ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ,
1476: LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE ,
1477: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1478: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1479: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1480: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1481: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID

Line 1485: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

1481: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
1482: AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)) raba,
1483: (SELECT ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ,
1484: LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE ,
1485: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1486: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1487: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1488: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1489: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID