VIEW: APPS.OKS_HEADERS_V

Source

View Text - Preformatted

SELECT k.id Contract_Id , k.contract_Number Contract_Number , NVL( k.Contract_Number_Modifier,' ') Contract_Modifier , k.Start_Date Start_Date , k.End_Date End_Date , k.sts_code Status , k.Short_Description Short_Description , px.party_id party_id , px.party_Number Party_Number , px.party_name Party_Name , bto.address1 bill2_Address1 , bto.address2 bill2_Address2 ,bto.city||','||bto.state||' '||bto.postal_code bill2_address3 , bto.Country bill2_Country , k.CURRENCY_CODE Currency , k.authoring_org_id Org_Id , k.inv_organization_id inv_org_id , k.last_update_date last_update_date , k.estimated_amount estimated_amount From Okc_k_Headers_V k , Okc_k_party_roles_v pr , hz_parties px ,Okx_cust_site_uses_v bto WHERE pr.dnz_chr_id = k.id And pr.rle_code = 'CUSTOMER' And pr.jtot_object1_code = 'OKX_PARTY' And px.party_id = TO_NUMBER( pr.object1_id1) And pr.chr_id = k.id And pr.cle_id Is Null And k.scs_code in ('SERVICE','WARRANTY') And bto.id1(+) = k.bill_to_site_use_id

View Text - HTML Formatted

SELECT K.ID CONTRACT_ID
, K.CONTRACT_NUMBER CONTRACT_NUMBER
, NVL( K.CONTRACT_NUMBER_MODIFIER
, ' ') CONTRACT_MODIFIER
, K.START_DATE START_DATE
, K.END_DATE END_DATE
, K.STS_CODE STATUS
, K.SHORT_DESCRIPTION SHORT_DESCRIPTION
, PX.PARTY_ID PARTY_ID
, PX.PARTY_NUMBER PARTY_NUMBER
, PX.PARTY_NAME PARTY_NAME
, BTO.ADDRESS1 BILL2_ADDRESS1
, BTO.ADDRESS2 BILL2_ADDRESS2
, BTO.CITY||'
, '||BTO.STATE||' '||BTO.POSTAL_CODE BILL2_ADDRESS3
, BTO.COUNTRY BILL2_COUNTRY
, K.CURRENCY_CODE CURRENCY
, K.AUTHORING_ORG_ID ORG_ID
, K.INV_ORGANIZATION_ID INV_ORG_ID
, K.LAST_UPDATE_DATE LAST_UPDATE_DATE
, K.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
FROM OKC_K_HEADERS_V K
, OKC_K_PARTY_ROLES_V PR
, HZ_PARTIES PX
, OKX_CUST_SITE_USES_V BTO
WHERE PR.DNZ_CHR_ID = K.ID
AND PR.RLE_CODE = 'CUSTOMER'
AND PR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND PX.PARTY_ID = TO_NUMBER( PR.OBJECT1_ID1)
AND PR.CHR_ID = K.ID
AND PR.CLE_ID IS NULL
AND K.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND BTO.ID1(+) = K.BILL_TO_SITE_USE_ID