DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 346: HZ_CUST_ACCOUNT_ROLES HCAR

342: WSH_DELIVERY_ASSIGNMENTS WDA,
343: HZ_PARTY_SITES HPS,
344: WSH_LOCATIONS WSL,
345: HZ_CUST_ACCT_SITES_ALL HCAS,
346: HZ_CUST_ACCOUNT_ROLES HCAR
347: WHERE WDA.delivery_id = p_delivery_id
348: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
349: AND WDD.SHIP_TO_LOCATION_ID = WSL.WSH_LOCATION_ID
350: AND WSL.SOURCE_LOCATION_ID = HPS.LOCATION_ID

Line 1524: FROM HZ_CUST_ACCOUNT_ROLES HCAR,

1520: )
1521: ),
1522: PER_CONTACT.LAST_UPDATE_DATE
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,