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_PARTIES

Line 1376: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

1372:
1373: FROM cn_commission_headers cch,
1374: (SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID, substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME,
1375: CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
1376: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1377: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) rac,
1378: (SELECT ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ,
1379: LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE ,
1380: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

Line 1397: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,

1393: AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)) rasa,
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

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 1404: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1403: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1404: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1405: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1406: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1407: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1408: ) rabc,

Line 1405: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1401: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1402: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1403: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1404: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1405: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1406: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1407: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1408: ) rabc,
1409: (SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID /* CONTACT_ID */ ,

Line 1412: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,

1408: ) rabc,
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

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 1419: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1418: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1419: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1420: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1421: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1422: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1423: ) rasc

Line 1420: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1416: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1417: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1418: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1419: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1420: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1421: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1422: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1423: ) rasc
1424: WHERE CCH.comm_lines_api_id = p_comm_lines_api_id

Line 1471: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

1467:
1468: FROM cn_comm_lines_api ccla,
1469: (SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID, substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME,
1470: CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
1471: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1472: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) rac,
1473: (SELECT ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */ ,
1474: LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE ,
1475: LOC.STATE FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,

Line 1492: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,

1488: AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)) rasa,
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

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 1499: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1498: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1499: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1500: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1501: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1502: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1503: ) rabc,

Line 1500: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1496: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1497: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1498: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1499: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1500: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1501: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1502: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1503: ) rabc,
1504: (SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID,

Line 1507: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,

1503: ) rabc,
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

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

Line 1514: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1513: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1514: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1515: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1516: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1517: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1518: ) rasc

Line 1515: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1511: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1512: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1513: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1514: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1515: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1516: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1517: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1518: ) rasc
1519: WHERE ccla.comm_lines_api_id = p_comm_lines_api_id