APPS.WSH_ECE_VIEWS_DEF dependencies on HZ_PARTIES

Line 45: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'

41: WSH_ECE_VIEWS_DEF.cont_phone_number_x
42: FROM HZ_CONTACT_POINTS contact,
43: HZ_CUST_ACCOUNT_ROLES acct_roles
44: WHERE acct_roles.CUST_ACCOUNT_ROLE_ID = contact_id_in
45: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'
46: AND acct_roles.PARTY_ID = contact.owner_table_id(+)
47: AND contact.CONTACT_POINT_TYPE IN ( 'PHONE', 'FAX', 'TELEX')
48: AND contact.PHONE_LINE_TYPE = 'GEN'
49: AND contact.PRIMARY_FLAG = 'Y';

Line 128: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'

124: HZ_CUST_ACCOUNT_ROLES hcar
125: WHERE hcar.CUST_ACCOUNT_ID = p_customer_id
126: AND contact.CONTACT_POINT_TYPE = 'PHONE'
127: AND contact.PRIMARY_FLAG = 'Y'
128: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'
129: AND contact.OWNER_TABLE_ID = hcar.PARTY_ID
130: AND contact.PHONE_LINE_TYPE = 'GEN'
131: AND hcar.status = 'A'
132: order by nvl(hcar.cust_acct_site_id,-99999);

Line 977: HZ_PARTIES REL_PARTY

973: ORG_CONT.JOB_TITLE
974: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
975: HZ_RELATIONSHIPS REL,
976: HZ_ORG_CONTACTS ORG_CONT,
977: HZ_PARTIES REL_PARTY
978: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
979: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
980: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
981: AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID

Line 982: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

978: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
979: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
980: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
981: AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
982: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
983: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
984: AND REL.DIRECTIONAL_FLAG = 'F'
985: AND REL.SUBJECT_ID = REL_PARTY.PARTY_ID;
986:

Line 983: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

979: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
980: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
981: AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
982: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
983: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
984: AND REL.DIRECTIONAL_FLAG = 'F'
985: AND REL.SUBJECT_ID = REL_PARTY.PARTY_ID;
986:
987: