DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on HZ_RELATIONSHIPS

Line 400: HZ_RELATIONSHIPS REL,

396: INTO CONTACT_NAME,L_PERSON_TITLE
397: FROM
398: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
399: HZ_PARTIES PARTY,
400: HZ_RELATIONSHIPS REL,
401: HZ_ORG_CONTACTS ORG_CONT,
402: HZ_PARTIES REL_PARTY
403: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
404: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID