DBA Data[Home] [Help]

APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 362: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

358: PARTY.PERSON_FIRST_NAME,
359: PARTY.PERSON_LAST_NAME,
360: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
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

Line 385: HZ_CUST_ACCOUNT_ROLES CAR

381: NVL(CONT_POINT.PHONE_LINE_TYPE
382: ,CONT_POINT.CONTACT_POINT_TYPE) PHONE_TYPE
383: FROM
384: HZ_CONTACT_POINTS CONT_POINT,
385: HZ_CUST_ACCOUNT_ROLES CAR
386: WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
387: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
388: AND CONT_POINT.CONTACT_POINT_TYPE not in ( 'EDI' , 'EMAIL' , 'WEB' ) ) PHONES,
389: WSH_DELIVERY_DETAILS WDD