DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_CUST_ACCT_SITES_ALL

Line 725: HZ_CUST_ACCT_SITES_ALL HCAS,

721: HCSU.SITE_USE_ID
722: FROM HZ_CUST_ACCOUNTS HCA,
723: HZ_PARTIES HP,
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

Line 751: HZ_CUST_ACCT_SITES_ALL HCAS,

747: SELECT HPS.LOCATION_ID,
748: HCA.CUST_ACCOUNT_ID,
749: HCSU.SITE_USE_ID
750: FROM HZ_CUST_SITE_USES_ALL HCSU,
751: HZ_CUST_ACCT_SITES_ALL HCAS,
752: HZ_PARTY_SITES HPS,
753: HZ_CUST_ACCOUNTS HCA,
754: HZ_CUST_ACCT_RELATE_ALL HCAR,
755: HZ_PARTIES HP