DBA Data[Home] [Help]

APPS.CN_ADJUSTMENTS_PKG dependencies on HZ_PARTIES

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 1399: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,

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

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

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

Line 1407: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

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

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

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

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

Line 1422: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1418: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
1419: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1420: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
1421: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1422: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1423: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
1424: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID /* AND REL.DIRECTIONAL_FLAG = 'F' */
1425: ) rasc
1426: WHERE CCH.comm_lines_api_id = p_comm_lines_api_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 1494: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL,

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

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

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

Line 1502: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

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

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

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

Line 1516: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 1517: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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