eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKI_ADDRESSES_V

Source

View Text - Preformatted


SELECT CASE WHEN okx.id1 = sil.bill_to_site_use_id THEN 'BILL_TO' ELSE 'SHIP_TO' END address_use , CASE WHEN okx.id1 = sil.bill_to_site_use_id THEN sil.bill_to_site_use_id ELSE SIL.SHIP_TO_SITE_USE_ID END SITE_USE_ID , okx.party_site_id , okx.location_id , NULL rgp_id , NULL rul_id , sil.chr_id , sil.cle_id , sil.contract_number , sil.contract_number_modifier , sil.line_number , okx.name , okx.country , okx.address1 , okx.address2 , okx.address3 , okx.address4 , okx.city , okx.postal_code , okx.state , okx.province , okx.county , null format_address , sil.scs_code FROM OKI_SOLD_ITM_LINES SIL,OKX_CUST_SITE_USES_V OKX WHERE okx.id1 in (sil.bill_to_site_use_id, sil.ship_to_site_use_id)

View Text - HTML Formatted

SELECT CASE WHEN OKX.ID1 = SIL.BILL_TO_SITE_USE_ID THEN 'BILL_TO' ELSE 'SHIP_TO' END ADDRESS_USE
, CASE WHEN OKX.ID1 = SIL.BILL_TO_SITE_USE_ID THEN SIL.BILL_TO_SITE_USE_ID ELSE SIL.SHIP_TO_SITE_USE_ID END SITE_USE_ID
, OKX.PARTY_SITE_ID
, OKX.LOCATION_ID
, NULL RGP_ID
, NULL RUL_ID
, SIL.CHR_ID
, SIL.CLE_ID
, SIL.CONTRACT_NUMBER
, SIL.CONTRACT_NUMBER_MODIFIER
, SIL.LINE_NUMBER
, OKX.NAME
, OKX.COUNTRY
, OKX.ADDRESS1
, OKX.ADDRESS2
, OKX.ADDRESS3
, OKX.ADDRESS4
, OKX.CITY
, OKX.POSTAL_CODE
, OKX.STATE
, OKX.PROVINCE
, OKX.COUNTY
, NULL FORMAT_ADDRESS
, SIL.SCS_CODE
FROM OKI_SOLD_ITM_LINES SIL
, OKX_CUST_SITE_USES_V OKX
WHERE OKX.ID1 IN (SIL.BILL_TO_SITE_USE_ID
, SIL.SHIP_TO_SITE_USE_ID)