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_ORG_CONTACTS

Line 1398: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

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

Line 1413: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

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

Line 1493: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

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

Line 1508: HZ_ORG_CONTACTS ORG_CONT, HZ_PARTIES REL_PARTY, HZ_CUST_ACCOUNTS ROLE_ACCT

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