DBA Data[Home] [Help]

APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_CONTACT_POINTS

Line 377: HZ_CONTACT_POINTS CONT_POINT,

373: CONT_POINT.PHONE_NUMBER PHONE_NUMBER,
374: NVL(CONT_POINT.PHONE_LINE_TYPE
375: ,CONT_POINT.CONTACT_POINT_TYPE) PHONE_TYPE
376: FROM
377: HZ_CONTACT_POINTS CONT_POINT,
378: HZ_CUST_ACCOUNT_ROLES CAR
379: WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
380: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
381: AND CONT_POINT.CONTACT_POINT_TYPE not in ( 'EDI' , 'EMAIL' , 'WEB' ) ) PHONES,