DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_PARTY_SITES

Line 727: HZ_PARTY_SITES HPS,

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

Line 752: HZ_PARTY_SITES HPS,

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