DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_PARTY_SITES

Line 847: HZ_PARTY_SITES HPS,

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
850: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
851: AND HCSU.SITE_USE_CODE IN ( p_site_use_code, 'SHIP_TO')

Line 872: HZ_PARTY_SITES HPS,

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
876: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID