View: OKI_BILL_TO_ADDRS_V

Product:	OKI - Contracts Intelligence
Description:	Bill to addresses for contracts.
Implementation/DBA Data:	APPS.OKI_BILL_TO_ADDRS_V

View Text

SELECT KAD.SITE_USE_ID
, KAD.PARTY_SITE_ID
, KAD.LOCATION_ID
, KAD.RUL_ID RULE_ID
, KAD.CHR_ID CONTRACT_ID
, KAD.CLE_ID CONTRACT_LINE_ID
, KAD.CONTRACT_NUMBER
, KAD.CONTRACT_NUMBER_MODIFIER
, KAD.LINE_NUMBER
, KAD.NAME
, KAD.COUNTRY
, KAD.ADDRESS1
, KAD.ADDRESS2
, KAD.ADDRESS3
, KAD.ADDRESS4
, KAD.CITY
, KAD.POSTAL_CODE
, KAD.STATE
, KAD.PROVINCE
, KAD.COUNTY
, KAD.FORMAT_ADDRESS
FROM OKI_ADDRESSES KAD
WHERE KAD.ADDRESS_USE = 'BILL_TO'
AND OKC_UTIL.GET_K_ACCESS_LEVEL(KAD.CHR_ID
, KAD.SCS_CODE) IN ('R'
, 'U')

Columns