VIEW: APPS.OKL_POOL_HEADER_UV

Source

View Text - Preformatted

SELECT POLB.ID ID, POLB.POOL_NUMBER POOL_NUMBER, POLB.CURRENCY_CODE CURRENCY_CODE, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT, POLB.DATE_CREATED DATE_CREATED, POLB.DATE_LAST_UPDATED DATE_LAST_UPDATED, POLB.DATE_LAST_RECONCILED DATE_LAST_RECONCILED, POLB.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC, POLB.KHR_ID KHR_ID, POLB.STATUS_CODE STATUS_CODE, PSTS.MEANING STATUS, NULL AGREEMENT_NUMBER, NULL AGREEMENT_STE_CODE, NULL AGREEMENT_STS_CODE, NULL AGREEMENT_STATUS, POLB.DESCRIPTION, POLB.SHORT_DESCRIPTION, POLB.LAST_UPDATE_DATE, POLB.ATTRIBUTE_CATEGORY, POLB.ATTRIBUTE1, POLB.ATTRIBUTE2, POLB.ATTRIBUTE3, POLB.ATTRIBUTE4, POLB.ATTRIBUTE5, POLB.ATTRIBUTE6, POLB.ATTRIBUTE7, POLB.ATTRIBUTE8, POLB.ATTRIBUTE9, POLB.ATTRIBUTE10, POLB.ATTRIBUTE11, POLB.ATTRIBUTE12, POLB.ATTRIBUTE13, POLB.ATTRIBUTE14, POLB.ATTRIBUTE15, POLB.DISPLAY_IN_LEASE_CENTER, FL.MEANING DISP_IN_LEASE_CNTR_MEANING, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID FROM OKL_POOLS POLB,OKC_STATUSES_TL PSTS,FND_LOOKUPS FL WHERE POLB.KHR_ID IS NULL AND POLB.STATUS_CODE = PSTS.CODE AND PSTS.LANGUAGE = USERENV('LANG') AND NVL(POLB.DISPLAY_IN_LEASE_CENTER,'N') = FL.LOOKUP_CODE AND FL.LOOKUP_TYPE = 'OKL_YES_NO' UNION SELECT POLB.ID ID, POLB.POOL_NUMBER POOL_NUMBER, POLB.CURRENCY_CODE CURRENCY_CODE, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT, POLB.DATE_CREATED DATE_CREATED, POLB.DATE_LAST_UPDATED DATE_LAST_UPDATED, POLB.DATE_LAST_RECONCILED DATE_LAST_RECONCILED, POLB.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC, POLB.KHR_ID KHR_ID, POLB.STATUS_CODE STATUS_CODE, PSTS.MEANING STATUS, CHRB.CONTRACT_NUMBER AGREEMENT_NUMBER, STSB.STE_CODE AGREEMENT_STE_CODE, CHRB.STS_CODE AGREEMENT_STS_CODE, CSTS.MEANING AGREEMENT_STATUS, POLB.DESCRIPTION, POLB.SHORT_DESCRIPTION, POLB.LAST_UPDATE_DATE, POLB.ATTRIBUTE_CATEGORY, POLB.ATTRIBUTE1, POLB.ATTRIBUTE2, POLB.ATTRIBUTE3, POLB.ATTRIBUTE4, POLB.ATTRIBUTE5, POLB.ATTRIBUTE6, POLB.ATTRIBUTE7, POLB.ATTRIBUTE8, POLB.ATTRIBUTE9, POLB.ATTRIBUTE10, POLB.ATTRIBUTE11, POLB.ATTRIBUTE12, POLB.ATTRIBUTE13, POLB.ATTRIBUTE14, POLB.ATTRIBUTE15, POLB.DISPLAY_IN_LEASE_CENTER, FL.MEANING DISP_IN_LEASE_CNTR_MEANING, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID FROM OKL_POOLS POLB, OKC_K_HEADERS_ALL_B CHRB, OKC_STATUSES_B STSB, OKC_STATUSES_TL CSTS, OKC_STATUSES_TL PSTS, FND_LOOKUPS FL WHERE POLB.KHR_ID = CHRB.ID AND CHRB.STS_CODE = CSTS.CODE AND CSTS.CODE = STSB.CODE AND CSTS.LANGUAGE = USERENV('LANG') AND POLB.STATUS_CODE = PSTS.CODE AND PSTS.LANGUAGE = USERENV('LANG') AND NVL(POLB.DISPLAY_IN_LEASE_CENTER,'N') = FL.LOOKUP_CODE AND FL.LOOKUP_TYPE = 'OKL_YES_NO'

View Text - HTML Formatted

SELECT POLB.ID ID
, POLB.POOL_NUMBER POOL_NUMBER
, POLB.CURRENCY_CODE CURRENCY_CODE
, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POLB.DATE_CREATED DATE_CREATED
, POLB.DATE_LAST_UPDATED DATE_LAST_UPDATED
, POLB.DATE_LAST_RECONCILED DATE_LAST_RECONCILED
, POLB.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC
, POLB.KHR_ID KHR_ID
, POLB.STATUS_CODE STATUS_CODE
, PSTS.MEANING STATUS
, NULL AGREEMENT_NUMBER
, NULL AGREEMENT_STE_CODE
, NULL AGREEMENT_STS_CODE
, NULL AGREEMENT_STATUS
, POLB.DESCRIPTION
, POLB.SHORT_DESCRIPTION
, POLB.LAST_UPDATE_DATE
, POLB.ATTRIBUTE_CATEGORY
, POLB.ATTRIBUTE1
, POLB.ATTRIBUTE2
, POLB.ATTRIBUTE3
, POLB.ATTRIBUTE4
, POLB.ATTRIBUTE5
, POLB.ATTRIBUTE6
, POLB.ATTRIBUTE7
, POLB.ATTRIBUTE8
, POLB.ATTRIBUTE9
, POLB.ATTRIBUTE10
, POLB.ATTRIBUTE11
, POLB.ATTRIBUTE12
, POLB.ATTRIBUTE13
, POLB.ATTRIBUTE14
, POLB.ATTRIBUTE15
, POLB.DISPLAY_IN_LEASE_CENTER
, FL.MEANING DISP_IN_LEASE_CNTR_MEANING
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKL_POOLS POLB
, OKC_STATUSES_TL PSTS
, FND_LOOKUPS FL
WHERE POLB.KHR_ID IS NULL
AND POLB.STATUS_CODE = PSTS.CODE
AND PSTS.LANGUAGE = USERENV('LANG')
AND NVL(POLB.DISPLAY_IN_LEASE_CENTER
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'OKL_YES_NO' UNION SELECT POLB.ID ID
, POLB.POOL_NUMBER POOL_NUMBER
, POLB.CURRENCY_CODE CURRENCY_CODE
, POLB.TOTAL_PRINCIPAL_AMOUNT TOTAL_PRINCIPAL_AMOUNT
, POLB.TOTAL_RECEIVABLE_AMOUNT TOTAL_RECEIVABLE_AMOUNT
, POLB.DATE_CREATED DATE_CREATED
, POLB.DATE_LAST_UPDATED DATE_LAST_UPDATED
, POLB.DATE_LAST_RECONCILED DATE_LAST_RECONCILED
, POLB.DATE_TOTAL_PRINCIPAL_CALC DATE_TOTAL_PRINCIPAL_CALC
, POLB.KHR_ID KHR_ID
, POLB.STATUS_CODE STATUS_CODE
, PSTS.MEANING STATUS
, CHRB.CONTRACT_NUMBER AGREEMENT_NUMBER
, STSB.STE_CODE AGREEMENT_STE_CODE
, CHRB.STS_CODE AGREEMENT_STS_CODE
, CSTS.MEANING AGREEMENT_STATUS
, POLB.DESCRIPTION
, POLB.SHORT_DESCRIPTION
, POLB.LAST_UPDATE_DATE
, POLB.ATTRIBUTE_CATEGORY
, POLB.ATTRIBUTE1
, POLB.ATTRIBUTE2
, POLB.ATTRIBUTE3
, POLB.ATTRIBUTE4
, POLB.ATTRIBUTE5
, POLB.ATTRIBUTE6
, POLB.ATTRIBUTE7
, POLB.ATTRIBUTE8
, POLB.ATTRIBUTE9
, POLB.ATTRIBUTE10
, POLB.ATTRIBUTE11
, POLB.ATTRIBUTE12
, POLB.ATTRIBUTE13
, POLB.ATTRIBUTE14
, POLB.ATTRIBUTE15
, POLB.DISPLAY_IN_LEASE_CENTER
, FL.MEANING DISP_IN_LEASE_CNTR_MEANING
, POLB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKL_POOLS POLB
, OKC_K_HEADERS_ALL_B CHRB
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL CSTS
, OKC_STATUSES_TL PSTS
, FND_LOOKUPS FL
WHERE POLB.KHR_ID = CHRB.ID
AND CHRB.STS_CODE = CSTS.CODE
AND CSTS.CODE = STSB.CODE
AND CSTS.LANGUAGE = USERENV('LANG')
AND POLB.STATUS_CODE = PSTS.CODE
AND PSTS.LANGUAGE = USERENV('LANG')
AND NVL(POLB.DISPLAY_IN_LEASE_CENTER
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'OKL_YES_NO'