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_CUST_ACCOUNTS

Line 1378: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

1374:
1375: FROM cn_commission_headers cch,
1376: (SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID, substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME,
1377: CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
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,

Line 1400: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

1396: (SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID /* CONTACT_ID */ ,
1397: substrb(PARTY.PERSON_LAST_NAME,1,50) PERSON_LAST_NAME,
1398: substrb(PARTY.PERSON_FIRST_NAME,1,40) PERSON_FIRST_NAME
1399: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,
1400: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT
1401: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1402: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
1403: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1404: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 1415: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

1411: (SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID /* CONTACT_ID */ ,
1412: substrb(PARTY.PERSON_LAST_NAME,1,50) PERSON_LAST_NAME,
1413: substrb(PARTY.PERSON_FIRST_NAME,1,40) PERSON_FIRST_NAME
1414: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,
1415: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT
1416: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1417: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
1418: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1419: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 1473: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

1469:
1470: FROM cn_comm_lines_api ccla,
1471: (SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID, substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME,
1472: CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
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,

Line 1495: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

1491: (SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID /* CONTACT_ID */ ,
1492: substrb(PARTY.PERSON_LAST_NAME,1,50) PERSON_LAST_NAME,
1493: substrb(PARTY.PERSON_FIRST_NAME,1,40) PERSON_FIRST_NAME
1494: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,
1495: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT
1496: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1497: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
1498: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1499: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 1510: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

1506: (SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID,
1507: substrb(PARTY.PERSON_LAST_NAME,1,50) PERSON_LAST_NAME,
1508: substrb(PARTY.PERSON_FIRST_NAME,1,40) PERSON_FIRST_NAME
1509: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,
1510: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT
1511: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1512: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
1513: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1514: AND REL.SUBJECT_ID = PARTY.PARTY_ID