VIEW: APPS.OKX_CONTRACTS_V

Source

View Text - Preformatted

SELECT chr.id ID1, '#' ID2, chr.contract_number||decode(chr.contract_number_modifier,null,null,'.')||chr.contract_number_modifier NAME, tl.short_description DESCRIPTION, chr.start_date START_DATE_ACTIVE, chr.end_date END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(chr.start_date,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(chr.end_date,trunc(sysdate))), 1,'I','A')) STATUS, NULL PRIMARY_UOM_CODE, scs_code SCS_CODE, sts_code STS_CODE, authoring_org_id ORG_ID, Inv_organization_id INV_ORG_ID, buy_or_sell BUY_OR_SELL, currency_code CURRENCY_CODE, chr_type CHR_TYPE FROM OKC_K_HEADERS_B CHR,OKC_K_HEADERS_TL TL WHERE CHR.ID = TL.ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT CHR.ID ID1
, '#' ID2
, CHR.CONTRACT_NUMBER||DECODE(CHR.CONTRACT_NUMBER_MODIFIER
, NULL
, NULL
, '.')||CHR.CONTRACT_NUMBER_MODIFIER NAME
, TL.SHORT_DESCRIPTION DESCRIPTION
, CHR.START_DATE START_DATE_ACTIVE
, CHR.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CHR.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(CHR.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, SCS_CODE SCS_CODE
, STS_CODE STS_CODE
, AUTHORING_ORG_ID ORG_ID
, INV_ORGANIZATION_ID INV_ORG_ID
, BUY_OR_SELL BUY_OR_SELL
, CURRENCY_CODE CURRENCY_CODE
, CHR_TYPE CHR_TYPE
FROM OKC_K_HEADERS_B CHR
, OKC_K_HEADERS_TL TL
WHERE CHR.ID = TL.ID
AND TL.LANGUAGE = USERENV('LANG')