[Home] [Help]
800: --
801: -- As part of TCA related changes ra_customers, ra_contacts views are
802: -- obsoleted in R12. The columns fetched from these views are fetched
803: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",
804: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".
805: --
806: -- Following declarations are commented.
807: --
808: --l_customer_id ra_customers.customer_id%TYPE;
1056: --
1057: -- As part of TCA related changes ra_customers, ra_contacts views are
1058: -- obsoleted in R12. The columns fetched from these views are fetched
1059: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",
1060: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".
1061: --
1062: -- Following six table alias are commented
1063: --, ra_customers oline_rc
1064: --, ra_contacts rcship
1087: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1088: SUBSTRB(PARTY.person_first_name,1,40) first_name
1089: FROM hz_cust_account_roles ACCT_ROLE,
1090: hz_parties PARTY,
1091: hz_relationships REL,
1092: hz_cust_accounts ROLE_ACCT
1093: WHERE
1094: ACCT_ROLE.party_id = REL.party_id
1095: AND ACCT_ROLE.role_type = 'CONTACT'
1104: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1105: SUBSTRB(PARTY.person_first_name,1,40) first_name
1106: FROM hz_cust_account_roles ACCT_ROLE,
1107: hz_parties PARTY,
1108: hz_relationships REL,
1109: hz_cust_accounts ROLE_ACCT
1110: WHERE
1111: ACCT_ROLE.party_id = REL.party_id
1112: AND ACCT_ROLE.role_type = 'CONTACT'
1121: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1122: SUBSTRB(PARTY.person_first_name,1,40) first_name
1123: FROM hz_cust_account_roles ACCT_ROLE,
1124: hz_parties PARTY,
1125: hz_relationships REL,
1126: hz_cust_accounts ROLE_ACCT
1127: WHERE
1128: ACCT_ROLE.party_id = REL.party_id
1129: AND ACCT_ROLE.role_type = 'CONTACT'
1138: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1139: SUBSTRB(PARTY.person_first_name,1,40) first_name
1140: FROM hz_cust_account_roles ACCT_ROLE,
1141: hz_parties PARTY,
1142: hz_relationships REL,
1143: hz_cust_accounts ROLE_ACCT
1144: WHERE
1145: ACCT_ROLE.party_id = REL.party_id
1146: AND ACCT_ROLE.role_type = 'CONTACT'
1155: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1156: SUBSTRB(PARTY.person_first_name,1,40) first_name
1157: FROM hz_cust_account_roles ACCT_ROLE,
1158: hz_parties PARTY,
1159: hz_relationships REL,
1160: hz_cust_accounts ROLE_ACCT
1161: WHERE
1162: ACCT_ROLE.party_id = REL.party_id
1163: AND ACCT_ROLE.role_type = 'CONTACT'
1604: --
1605: -- As part of TCA related changes ra_customers, ra_contacts views are
1606: -- obsoleted in R12. The columns fetched from these views are fetched
1607: -- from "HZ_PARTIES", "HZ_CUST_ACCOUNTS", "HZ_CUST_ACCOUNT_ROLES",
1608: -- "HZ_CUST_ACCOUNTS", "HZ_RELATIONSHIPS".
1609: --
1610: -- Following six table alias are commented
1611: --, ra_contacts rcship
1612: --, ra_contacts dcontact
1621: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1622: SUBSTRB(PARTY.person_first_name,1,40) first_name
1623: FROM hz_cust_account_roles ACCT_ROLE,
1624: hz_parties PARTY,
1625: hz_relationships REL,
1626: hz_cust_accounts ROLE_ACCT
1627: WHERE
1628: ACCT_ROLE.party_id = REL.party_id
1629: AND ACCT_ROLE.role_type = 'CONTACT'
1638: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1639: SUBSTRB(PARTY.person_first_name,1,40) first_name
1640: FROM hz_cust_account_roles ACCT_ROLE,
1641: hz_parties PARTY,
1642: hz_relationships REL,
1643: hz_cust_accounts ROLE_ACCT
1644: WHERE
1645: ACCT_ROLE.party_id = REL.party_id
1646: AND ACCT_ROLE.role_type = 'CONTACT'
1655: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1656: SUBSTRB(PARTY.person_first_name,1,40) first_name
1657: FROM hz_cust_account_roles ACCT_ROLE,
1658: hz_parties PARTY,
1659: hz_relationships REL,
1660: hz_cust_accounts ROLE_ACCT
1661: WHERE
1662: ACCT_ROLE.party_id = REL.party_id
1663: AND ACCT_ROLE.role_type = 'CONTACT'
1672: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1673: SUBSTRB(PARTY.person_first_name,1,40) first_name
1674: FROM hz_cust_account_roles ACCT_ROLE,
1675: hz_parties PARTY,
1676: hz_relationships REL,
1677: hz_cust_accounts ROLE_ACCT
1678: WHERE
1679: ACCT_ROLE.party_id = REL.party_id
1680: AND ACCT_ROLE.role_type = 'CONTACT'