DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_CUST_ACCT_SITES_ALL

Line 845: HZ_CUST_ACCT_SITES_ALL HCAS,

841: HCSU.SITE_USE_ID
842: FROM HZ_CUST_ACCOUNTS HCA,
843: HZ_PARTIES HP,
844: HZ_CUST_SITE_USES_ALL HCSU,
845: HZ_CUST_ACCT_SITES_ALL HCAS,
846: -- ORG_ORGANIZATION_DEFINITIONS OOD,
847: HZ_PARTY_SITES HPS,
848: HZ_LOCATIONS HL
849: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID

Line 871: HZ_CUST_ACCT_SITES_ALL HCAS,

867: SELECT HPS.LOCATION_ID,
868: HCA.CUST_ACCOUNT_ID,
869: HCSU.SITE_USE_ID
870: FROM HZ_CUST_SITE_USES_ALL HCSU,
871: HZ_CUST_ACCT_SITES_ALL HCAS,
872: HZ_PARTY_SITES HPS,
873: HZ_CUST_ACCOUNTS HCA,
874: HZ_CUST_ACCT_RELATE_ALL HCAR,
875: HZ_PARTIES HP