APPS.ARI_UTILITIES dependencies on HZ_CUST_ACCOUNT_ROLES

Line 833: from hz_cust_account_roles SUB,

829: select contact_id from (
830: select SUB.cust_account_role_id contact_id, SUB.CUST_ACCT_SITE_ID , SROLES.responsibility_type ,SROLES.PRIMARY_FLAG ,
831: row_number() OVER ( partition by SROLES.responsibility_type , SUB.CUST_ACCT_SITE_ID order by SROLES.PRIMARY_FLAG DESC NULLS LAST, SUB.last_update_date desc) last_update_record,
832: decode(SROLES.responsibility_type,p_contact_role_type,111,999) resp_code
833: from hz_cust_account_roles SUB,
834: hz_role_responsibility SROLES
835: where SUB.cust_account_role_id = SROLES.CUST_ACCOUNT_ROLE_ID AND
836: SUB.status = 'A' AND
837: SUB.CUST_ACCOUNT_ID = p_customer_id

Line 849: from hz_cust_account_roles SUB,

845: select contact_id from (
846: select SUB.cust_account_role_id contact_id, SUB.CUST_ACCT_SITE_ID , SROLES.responsibility_type ,SROLES.PRIMARY_FLAG ,
847: row_number() OVER ( partition by SROLES.responsibility_type , SUB.CUST_ACCT_SITE_ID order by SROLES.PRIMARY_FLAG DESC NULLS LAST, SUB.last_update_date desc) last_update_record,
848: decode(SROLES.responsibility_type,p_contact_role_type,111,999) resp_code
849: from hz_cust_account_roles SUB,
850: hz_role_responsibility SROLES
851: where SUB.cust_account_role_id = SROLES.CUST_ACCOUNT_ROLE_ID AND
852: SUB.status = 'A' AND
853: SUB.CUST_ACCOUNT_ID = p_customer_id

Line 925: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

921: --
922: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
923: substrb(PARTY.PERSON_LAST_NAME,1,50)
924: INTO l_contact_name
925: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
926: HZ_PARTIES PARTY,
927: HZ_RELATIONSHIPS REL
928: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
929: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 977: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

973: IF p_contact_id IS NOT NULL THEN
974: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
975: substrb(PARTY.PERSON_LAST_NAME,1,50)
976: INTO l_contact_name
977: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
978: HZ_PARTIES PARTY,
979: HZ_RELATIONSHIPS REL
980: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
981: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 1034: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

1030: p_primary_flag IN VARCHAR2 DEFAULT 'Y') IS
1031: SELECT phone_id FROM
1032: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1033: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1034: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1035: HZ_CONTACT_POINTS CONT_POINT
1036: WHERE
1037: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1038: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID

Line 1121: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

1117: p_primary_flag IN VARCHAR2 DEFAULT 'Y') IS
1118: SELECT phone_id FROM
1119: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1120: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1121: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1122: HZ_CONTACT_POINTS CONT_POINT
1123: WHERE
1124: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1125: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID

Line 1813: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,

1809:
1810: CURSOR contact_cur(p_customer_id IN NUMBER DEFAULT NULL,
1811: p_customer_acct_site_id IN NUMBER DEFAULT NULL ) IS
1812: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
1813: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
1814: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
1815: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
1816: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
1817: and hrr.cust_account_role_id = hcar.cust_account_role_id

Line 1836: FROM hz_cust_account_roles acct_role,

1832: and hcar.status='A';
1833:
1834: CURSOR email_addr_cur (l_contact_id IN NUMBER DEFAULT NULL) IS
1835: SELECT cont_point.email_Address
1836: FROM hz_cust_account_roles acct_role,
1837: hz_contact_points cont_point
1838: WHERE acct_role.cust_account_role_id =l_contact_id
1839: AND acct_role.party_id = cont_point.owner_table_id
1840: AND cont_point.owner_table_name = 'HZ_PARTIES'