APPS.CN_ADJUSTMENTS_PKG dependencies on HZ_CUST_ACCOUNTS

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 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 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 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