DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 316: HZ_CUST_ACCOUNT_ROLES HCAR

312: WSH_DELIVERY_ASSIGNMENTS WDA,
313: HZ_PARTY_SITES HPS,
314: WSH_LOCATIONS WSL,
315: HZ_CUST_ACCT_SITES_ALL HCAS,
316: HZ_CUST_ACCOUNT_ROLES HCAR
317: WHERE WDA.delivery_id = p_delivery_id
318: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
319: AND WDD.SHIP_TO_LOCATION_ID = WSL.WSH_LOCATION_ID
320: AND WSL.SOURCE_LOCATION_ID = HPS.LOCATION_ID

Line 1485: FROM HZ_CUST_ACCOUNT_ROLES HCAR,

1481: )
1482: ),
1483: PER_CONTACT.LAST_UPDATE_DATE
1484: ) LAST_UPDATE_DATE
1485: FROM HZ_CUST_ACCOUNT_ROLES HCAR,
1486: HZ_RELATIONSHIPS HREL,
1487: HZ_ORG_CONTACTS HOC,
1488: HZ_CONTACT_POINTS PHONE_CONTACT,
1489: HZ_PARTIES PER_CONTACT,