DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CONTACT_POINTS

Line 1527: HZ_CONTACT_POINTS PHONE_CONTACT,

1523: ) LAST_UPDATE_DATE
1524: FROM HZ_CUST_ACCOUNT_ROLES HCAR,
1525: HZ_RELATIONSHIPS HREL,
1526: HZ_ORG_CONTACTS HOC,
1527: HZ_CONTACT_POINTS PHONE_CONTACT,
1528: HZ_PARTIES PER_CONTACT,
1529: WSH_OTM_LOC_CONTACTS_GTMP WLCT
1530: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1531: AND HCAR.ROLE_TYPE = 'CONTACT'