eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 957: HZ_PARTIES REL_PARTY

953: ORG_CONT.JOB_TITLE
954: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
955: HZ_RELATIONSHIPS REL,
956: HZ_ORG_CONTACTS ORG_CONT,
957: HZ_PARTIES REL_PARTY
958: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
959: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
960: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
961: AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID

Line 962: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

958: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
959: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
960: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
961: AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
962: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
963: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
964: AND REL.DIRECTIONAL_FLAG = 'F'
965: AND REL.SUBJECT_ID = REL_PARTY.PARTY_ID;
966:

Line 963: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

959: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
960: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
961: AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
962: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
963: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
964: AND REL.DIRECTIONAL_FLAG = 'F'
965: AND REL.SUBJECT_ID = REL_PARTY.PARTY_ID;
966:
967: