[Oracle]R12:客戶資料

SELECT HCSA.ORG_ID,
       HCA.CUST_ACCOUNT_ID,
       HCA.ACCOUNT_NUMBER,
   HP.PARTY_NAME
  FROM HZ_PARTIES             HP,
       HZ_PARTY_SITES         HPS,
       HZ_LOCATIONS           HL,
       HZ_CUST_ACCOUNTS_ALL   HCA,
       HZ_CUST_ACCT_SITES_ALL HCSA,
       HZ_CUST_SITE_USES_ALL  HCSU
 WHERE HP.PARTY_ID = HPS.PARTY_ID
   AND HPS.LOCATION_ID = HL.LOCATION_ID
   AND HP.PARTY_ID = HCA.PARTY_ID
   AND HCSA.PARTY_SITE_ID = HPS.PARTY_SITE_ID
   AND HCSU.CUST_ACCT_SITE_ID = HCSA.CUST_ACCT_SITE_ID
   AND HCA.CUST_ACCOUNT_ID = HCSA.CUST_ACCOUNT_ID
      --AND HP.PARTY_ID = 20054
   AND HP.PARTY_NAME = 'XXXX'
   AND HPS.IDENTIFYING_ADDRESS_FLAG = 'Y'
   AND HCSA.ORG_ID = 136
 ORDER BY HP.PARTY_NUMBER, HCSU.SITE_USE_CODE, HCSU.LOCATION