DBA Data[Home] [Help]

APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_ORG_CONTACTS

Line 365: HZ_ORG_CONTACTS ORG_CONT,

361: FROM
362: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
363: HZ_PARTIES PARTY,
364: HZ_RELATIONSHIPS REL,
365: HZ_ORG_CONTACTS ORG_CONT,
366: HZ_CUST_ACCOUNTS ROLE_ACCT
367: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
368: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
369: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID