DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_LOCATIONS

Line 728: HZ_LOCATIONS HL

724: HZ_CUST_SITE_USES_ALL HCSU,
725: HZ_CUST_ACCT_SITES_ALL HCAS,
726: -- ORG_ORGANIZATION_DEFINITIONS OOD,
727: HZ_PARTY_SITES HPS,
728: HZ_LOCATIONS HL
729: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
730: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
731: AND HCSU.SITE_USE_CODE IN ( p_site_use_code, 'SHIP_TO')
732: AND HCSU.STATUS = 'A'