DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CONTACT_POINTS

Line 1488: HZ_CONTACT_POINTS PHONE_CONTACT,

1484: ) LAST_UPDATE_DATE
1485: FROM HZ_CUST_ACCOUNT_ROLES HCAR,
1486: HZ_RELATIONSHIPS HREL,
1487: HZ_ORG_CONTACTS HOC,
1488: HZ_CONTACT_POINTS PHONE_CONTACT,
1489: HZ_PARTIES PER_CONTACT,
1490: WSH_OTM_LOC_CONTACTS_GTMP WLCT
1491: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1492: AND HCAR.ROLE_TYPE = 'CONTACT'