VIEW: APPS.OKI_SHIP_TO_ADDRS_V

Source

View Text - Preformatted

SELECT sil.ship_to_site_use_id site_use_id , okx.party_site_id , okx.location_id , NULL rule_id , sil.chr_id contract_id , sil.cle_id contract_line_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 FROM OKI_SOLD_ITM_LINES SIL,OKX_CUST_SITE_USES_V OKX WHERE okx.id1 = sil.ship_to_site_use_id and okc_util.get_k_access_level(sil.chr_id, sil.scs_code) in ('R','U')

View Text - HTML Formatted

SELECT SIL.SHIP_TO_SITE_USE_ID SITE_USE_ID
, OKX.PARTY_SITE_ID
, OKX.LOCATION_ID
, NULL RULE_ID
, SIL.CHR_ID CONTRACT_ID
, SIL.CLE_ID CONTRACT_LINE_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
FROM OKI_SOLD_ITM_LINES SIL
, OKX_CUST_SITE_USES_V OKX
WHERE OKX.ID1 = SIL.SHIP_TO_SITE_USE_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SIL.CHR_ID
, SIL.SCS_CODE) IN ('R'
, 'U')