DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_CUST_SITE_USES_ALL

Line 844: HZ_CUST_SITE_USES_ALL HCSU,

840: HCA.CUST_ACCOUNT_ID,
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

Line 870: FROM HZ_CUST_SITE_USES_ALL HCSU,

866: CURSOR c_rel_cust_loc_cur IS
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,