VIEW: APPS.OKL_SEC_HEADERS_UV

Source

View Text - Preformatted

SELECT CHRB.ID ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION, CHRB.START_DATE START_DATE, CHRB.END_DATE END_DATE, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID, CHRB.INV_ORGANIZATION_ID INV_ORG_ID, CHRB.STS_CODE STS_CODE, STSB.STE_CODE STE_CODE, STSL.MEANING STS_MEANING, CURR.CURRENCY_CODE CURRENCY_CODE, CURR.NAME CURRENCY, KLPB.ID PDT_ID, KLPB.NAME PRODUCT_NAME, KLPB.DESCRIPTION PRODUCT_DESCRIPTION, POLB.POOL_NUMBER POOL_NUMBER, POLB.ID POOL_ID, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID FROM OKC_K_HEADERS_B CHRB,OKC_STATUSES_B STSB,OKC_STATUSES_TL STSL,OKC_K_HEADERS_TL CHRT,OKL_K_HEADERS KHRB,OKL_PRODUCTS KLPB,OKL_POOLS_ALL POLB,FND_CURRENCIES_VL CURR WHERE CHRT.ID = CHRB.ID AND STSL.LANGUAGE = USERENV('LANG') AND CHRT.LANGUAGE = USERENV('LANG') AND STSL.CODE = CHRB.STS_CODE AND STSB.CODE = STSL.CODE AND KHRB.ID = CHRB.ID AND KLPB.ID = KHRB.PDT_ID AND CHRB.CURRENCY_CODE = CURR.CURRENCY_CODE AND CHRB.SCS_CODE = 'INVESTOR' AND CHRB.ID = POLB.KHR_ID

View Text - HTML Formatted

SELECT CHRB.ID ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHRB.INV_ORGANIZATION_ID INV_ORG_ID
, CHRB.STS_CODE STS_CODE
, STSB.STE_CODE STE_CODE
, STSL.MEANING STS_MEANING
, CURR.CURRENCY_CODE CURRENCY_CODE
, CURR.NAME CURRENCY
, KLPB.ID PDT_ID
, KLPB.NAME PRODUCT_NAME
, KLPB.DESCRIPTION PRODUCT_DESCRIPTION
, POLB.POOL_NUMBER POOL_NUMBER
, POLB.ID POOL_ID
, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_B CHRB
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STSL
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHRB
, OKL_PRODUCTS KLPB
, OKL_POOLS_ALL POLB
, FND_CURRENCIES_VL CURR
WHERE CHRT.ID = CHRB.ID
AND STSL.LANGUAGE = USERENV('LANG')
AND CHRT.LANGUAGE = USERENV('LANG')
AND STSL.CODE = CHRB.STS_CODE
AND STSB.CODE = STSL.CODE
AND KHRB.ID = CHRB.ID
AND KLPB.ID = KHRB.PDT_ID
AND CHRB.CURRENCY_CODE = CURR.CURRENCY_CODE
AND CHRB.SCS_CODE = 'INVESTOR'
AND CHRB.ID = POLB.KHR_ID