11i to R12.1.3 key queries

• R12.1.3  for apps.ra_site_uses_all

              (select location, site_use_id, org_id, CUST_ACCT_SITE_ID address_id
              , attribute14, site_use_code
              from HZ_CUST_SITE_USES_ALL)

• R12.1.3 for ra_addresses_all

          (select loc.country, ACCT_SITE.CUST_ACCT_SITE_ID address_id , province , postal_code, state ,loc.country country_code, city

          , address1, address2, address3, address4 , CUST_ACCOUNT_ID customer_id
          from HZ_PARTY_SITES PARTY_SITE,
          HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
          HZ_LOCATIONS LOC,
          HZ_CUST_ACCT_SITES_ALL ACCT_SITE
          WHERE ACCT_SITE.PARTY_SITE_ID     = PARTY_SITE.PARTY_SITE_ID
          AND LOC.LOCATION_ID               = PARTY_SITE.LOCATION_ID
          AND LOC.LOCATION_ID               = LOC_ASSIGN.LOCATION_ID
          AND NVL ( ACCT_SITE.ORG_ID, -99 ) = NVL ( LOC_ASSIGN.ORG_ID, -99 ) )

• R12.1.3 for ra_customers 

(select substrb(PARTY.PARTY_NAME,1,50) customer_name,
CUST_ACCT.ACCOUNT_NUMBER customer_number,
CUST_ACCT.CUST_ACCOUNT_ID customer_id,
PARTY.PARTY_ID party_id, PARTY.STATUS
from HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
where CUST_ACCT.PARTY_ID = PARTY.PARTY_ID)

• Customer data for Ship_to
  select HCA.ACCOUNT_NUMBER
  , HP.PARTY_NAME CUSTOMER_NAME
  , HCSUA.SITE_USE_CODE
  , (hp.address1 || ','|| hp.address2 ||','||hp.address3 || ',' ||hp.address4 ||','||hp.country) address
  , HCSUA.FREIGHT_TERM
  , NVL2(HCSUA.PAYMENT_TERM_ID,(select name from RA_TERMS where TERM_ID = HCSUA.PAYMENT_TERM_ID), null) PAYMENT_TERM
  --,  HCSUA.SITE_USE_ID
  --, HCSUA.CUST_ACCT_SITE_ID
  --, HCASA.CUST_ACCOUNT_ID customer_id
  from
  HZ_CUST_SITE_USES_ALL HCSUA ,
  HZ_CUST_ACCT_SITES_ALL HCASA,
  HZ_CUST_ACCOUNTS HCA,
  HZ_PARTIES HP
  where 1=1
  and HCSUA.SITE_USE_CODE  ='SHIP_TO'
  and HCSUA.ORG_ID = -- operating_unit
  and HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_ID
  and HCASA.ORG_ID =
  and HCA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_ID
  and HP.PARTY_ID = HCA.PARTY_ID
  and hca.status = 'A'
  and HCSUA.STATUS = 'A'
  and HCASA.STATUS = 'A';