VIEW: APPS.OKL_LA_HEADERS_UV

Source

View Text - Preformatted

SELECT CHR.AUTHORING_ORG_ID AUTHORING_ORG_ID, CHR.START_DATE START_DATE, CHR.END_DATE END_DATE, STL.MEANING MEANING, TL.SHORT_DESCRIPTION SHORT_DESCRIPTION, CHR.STS_CODE STS_CODE, CHR.CONTRACT_NUMBER CONTRACT_NUMBER, PROG.SHORT_DESCRIPTION PROGRAM_NAME, KLP.ID PDT_ID, KLP.NAME PRODUCT_NAME, KLP.DESCRIPTION PRODUCT_DESCRIPTION, CHR.ID ID, CHR.INV_ORGANIZATION_ID INV_ORG_ID, KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID FROM OKC_K_HEADERS_B CHR,OKC_STATUSES_TL STL,OKC_K_HEADERS_TL TL,OKL_K_HEADERS KHR,OKL_PRODUCTS KLP,OKC_K_HEADERS_TL PROG WHERE TL.ID = CHR.ID AND STL.CODE = CHR.STS_CODE AND TL.LANGUAGE = USERENV('LANG') AND STL.LANGUAGE = USERENV('LANG') AND KHR.ID = CHR.ID AND KLP.ID(+) = KHR.PDT_ID AND PROG.ID(+) = KHR.KHR_ID

View Text - HTML Formatted

SELECT CHR.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, STL.MEANING MEANING
, TL.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHR.STS_CODE STS_CODE
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PROG.SHORT_DESCRIPTION PROGRAM_NAME
, KLP.ID PDT_ID
, KLP.NAME PRODUCT_NAME
, KLP.DESCRIPTION PRODUCT_DESCRIPTION
, CHR.ID ID
, CHR.INV_ORGANIZATION_ID INV_ORG_ID
, KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_B CHR
, OKC_STATUSES_TL STL
, OKC_K_HEADERS_TL TL
, OKL_K_HEADERS KHR
, OKL_PRODUCTS KLP
, OKC_K_HEADERS_TL PROG
WHERE TL.ID = CHR.ID
AND STL.CODE = CHR.STS_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND STL.LANGUAGE = USERENV('LANG')
AND KHR.ID = CHR.ID
AND KLP.ID(+) = KHR.PDT_ID
AND PROG.ID(+) = KHR.KHR_ID