APPS.ARI_UTILITIES dependencies on HZ_CUST_ACCOUNT_ROLES

Line 875: from hz_cust_account_roles SUB,

871: select contact_id from (
872: select SUB.cust_account_role_id contact_id, SUB.CUST_ACCT_SITE_ID , SROLES.responsibility_type ,SROLES.PRIMARY_FLAG ,
873: 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,
874: decode(SROLES.responsibility_type,p_contact_role_type,111,999) resp_code
875: from hz_cust_account_roles SUB,
876: hz_role_responsibility SROLES
877: where SUB.cust_account_role_id = SROLES.CUST_ACCOUNT_ROLE_ID AND
878: SUB.status = 'A' AND
879: SUB.CUST_ACCOUNT_ID = p_customer_id

Line 891: from hz_cust_account_roles SUB,

887: select contact_id from (
888: select SUB.cust_account_role_id contact_id, SUB.CUST_ACCT_SITE_ID , SROLES.responsibility_type ,SROLES.PRIMARY_FLAG ,
889: 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,
890: decode(SROLES.responsibility_type,p_contact_role_type,111,999) resp_code
891: from hz_cust_account_roles SUB,
892: hz_role_responsibility SROLES
893: where SUB.cust_account_role_id = SROLES.CUST_ACCOUNT_ROLE_ID AND
894: SUB.status = 'A' AND
895: SUB.CUST_ACCOUNT_ID = p_customer_id

Line 967: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

963: --
964: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
965: substrb(PARTY.PERSON_LAST_NAME,1,50)
966: INTO l_contact_name
967: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
968: HZ_PARTIES PARTY,
969: HZ_RELATIONSHIPS REL
970: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
971: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 1019: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

1015: IF p_contact_id IS NOT NULL THEN
1016: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
1017: substrb(PARTY.PERSON_LAST_NAME,1,50)
1018: INTO l_contact_name
1019: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1020: HZ_PARTIES PARTY,
1021: HZ_RELATIONSHIPS REL
1022: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1023: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 1077: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

1073: p_primary_flag IN VARCHAR2 DEFAULT 'Y') IS
1074: SELECT phone_id FROM
1075: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1076: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1077: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1078: HZ_CONTACT_POINTS CONT_POINT
1079: WHERE
1080: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1081: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID

Line 1164: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

1160: p_primary_flag IN VARCHAR2 DEFAULT 'Y') IS
1161: SELECT phone_id FROM
1162: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1163: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1164: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1165: HZ_CONTACT_POINTS CONT_POINT
1166: WHERE
1167: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1168: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID

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

2246:
2247: CURSOR contact_cur(p_customer_id IN NUMBER ,
2248: p_customer_acct_site_id IN NUMBER ) IS
2249: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
2250: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
2251: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
2252: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
2253: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
2254: and hrr.cust_account_role_id = hcar.cust_account_role_id

Line 2273: FROM hz_cust_account_roles acct_role,

2269: and hcar.status='A';
2270:
2271: CURSOR email_addr_cur (l_contact_id IN NUMBER DEFAULT NULL) IS
2272: SELECT cont_point.email_Address
2273: FROM hz_cust_account_roles acct_role,
2274: hz_contact_points cont_point
2275: WHERE acct_role.cust_account_role_id =l_contact_id
2276: AND acct_role.party_id = cont_point.owner_table_id
2277: AND cont_point.owner_table_name = 'HZ_PARTIES'