APPS.ARI_UTILITIES dependencies on HZ_ROLE_RESPONSIBILITY

Line 834: hz_role_responsibility SROLES

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
838: AND ( SUB.CUST_ACCT_SITE_ID = p_customer_site_use_id)

Line 850: hz_role_responsibility SROLES

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
854: AND (SUB.CUST_ACCT_SITE_ID IS NULL)

Line 1815: fnd_lookup_values_vl lookups,hz_role_responsibility hrr

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
1818: and hcar.CUST_ACCOUNT_ID = p_customer_id
1819: AND hcar.ROLE_TYPE = 'CONTACT'