VIEW: APPS.OKS_HEADER_DETAILS_V

Source

View Text - Preformatted

SELECT k.id CONTRACT_ID ,k.contract_number CONTRACT_NUMBER ,k.contract_number_modifier CONTRACT_NUMBER_MODIFIER ,k.start_date START_DATE ,k.end_date END_DATE ,(select st.meaning from okc_statuses_v st where st.code=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.description HEADER_BTO_ADDRESS ,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_b pr ,hz_parties px ,OKX_CUST_SITE_USES_V bto WHERE pr.dnz_chr_id = k.id And pr.cle_id Is Null And px.party_id = pr.object1_id1 And k.scs_code in ('SERVICE','WARRANTY') And pr.rle_code = 'CUSTOMER' And pr.chr_id = k.id And bto.id1(+) = k.BILL_TO_SITE_USE_ID

View Text - HTML Formatted

SELECT K.ID CONTRACT_ID
, K.CONTRACT_NUMBER CONTRACT_NUMBER
, K.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, K.START_DATE START_DATE
, K.END_DATE END_DATE
, (SELECT ST.MEANING
FROM OKC_STATUSES_V ST
WHERE ST.CODE=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.DESCRIPTION HEADER_BTO_ADDRESS
, 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_B PR
, HZ_PARTIES PX
, OKX_CUST_SITE_USES_V BTO
WHERE PR.DNZ_CHR_ID = K.ID
AND PR.CLE_ID IS NULL
AND PX.PARTY_ID = PR.OBJECT1_ID1
AND K.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND PR.RLE_CODE = 'CUSTOMER'
AND PR.CHR_ID = K.ID
AND BTO.ID1(+) = K.BILL_TO_SITE_USE_ID