View: OKL_SUBSIDIES_UV

Product:	OKL - Leasing and Finance Management
Description:	User interface view for subsidy setup page
Implementation/DBA Data:	APPS.OKL_SUBSIDIES_UV

View Text

SELECT SUBB.ID ID
, SUBB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SUBB.ORG_ID ORG_ID
, HRO.NAME ORGANIZATION_NAME
, HRO.NAME ORGANIZATION_CODE
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, SUBT.DESCRIPTION DESCRIPTION
, SUBB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SUBB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, TO_CHAR(SUBB.EXPIRE_AFTER_DAYS) EXPIRE_AFTER_DAYS
, SUBB.CURRENCY_CODE CURRENCY_CODE
, SUBB.EXCLUSIVE_YN EXCLUSIVE_YN
, SUBB.APPLICABLE_TO_RELEASE_YN APPLICABLE_TO_RELEASE_YN
, SUBB.SUBSIDY_CALC_BASIS SUBSIDY_CALC_BASIS
, FLK1.MEANING SUBSIDY_CALC_BASIS_MEANING
, TO_CHAR(SUBB.AMOUNT) AMOUNT
, TO_CHAR(SUBB.PERCENT) PERCENT
, SUBB.FORMULA_ID FORMULA_ID
, FMLB1.NAME CALCULATION_FORMULA_NAME
, FMLT1.DESCRIPTION CALCULATION_FORMULA_DESCR
, TO_CHAR(SUBB.RATE_POINTS) RATE_POINTS
, TO_CHAR(SUBB.MAXIMUM_TERM) MAXIMUM_TERM
, SUBB.VENDOR_ID VENDOR_ID
, POV.VENDOR_NAME VENDOR_NAME
, SUBB.ACCOUNTING_METHOD_CODE ACCOUNTING_METHOD_CODE
, FLK2.MEANING ACCOUNTING_METHOD_MEANING
, SUBB.RECOURSE_YN RECOURSE_YN_CODE
, FLK3.MEANING RECOURSE_YN_MEANING
, SUBB.TERMINATION_REFUND_BASIS TERMINATION_REFUND_BASIS
, FLK4.MEANING TERM_REFUND_BASIS_MEANING
, SUBB.REFUND_FORMULA_ID REFUND_FORMULA_ID
, FMLB2.NAME REFUND_FORMULA_NAME
, FMLT2.DESCRIPTION REFUND_FORMULA_DESCR
, SUBB.STREAM_TYPE_ID STREAM_TYPE_ID
, STYB.CODE STREAM_TYPE_CODE
, STYT.DESCRIPTION STREAM_TYPE_DESCR
, SUBB.RECEIPT_METHOD_CODE RECEIPT_METHOD_CODE
, FLK5.MEANING RECEIPT_METHOD_MEANING
, SUBB.CUSTOMER_VISIBLE_YN CUST_VISIBLE_YN_CODE
, FLK6.MEANING CUST_VISIBLE_YN_MEANING
, TO_CHAR(SUBB.MAXIMUM_FINANCED_AMOUNT) MAXIMUM_FINANCED_AMOUNT
, TO_CHAR(SUBB.MAXIMUM_SUBSIDY_AMOUNT) MAXIMUM_SUBSIDY_AMOUNT
, SUBB.TRANSFER_BASIS_CODE TRANSFER_BASIS_CODE
, SUBP.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SUBP.ID POOL_ID
, FLK7.MEANING SUBSIDY_POOL_STATUS_MEANING
, SUBP.DECISION_STATUS_CODE DECISION_STATUS_CODE
FROM FND_LOOKUPS FLK1
, FND_LOOKUPS FLK2
, FND_LOOKUPS FLK3
, FND_LOOKUPS FLK4
, FND_LOOKUPS FLK5
, FND_LOOKUPS FLK6
, FND_LOOKUPS FLK7
, OKL_FORMULAE_B FMLB1
, OKL_FORMULAE_TL FMLT1
, OKL_FORMULAE_B FMLB2
, OKL_FORMULAE_TL FMLT2
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYT
, HR_OPERATING_UNITS HRO
, PO_VENDORS POV
, OKL_SUBSIDIES_TL SUBT
, OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDY_POOLS_B SUBP
WHERE SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND STYT.ID(+) = STYB.ID
AND HRO.ORGANIZATION_ID(+) = SUBB.ORG_ID
AND STYT.LANGUAGE(+) = USERENV('LANG')
AND STYB.ID(+) = SUBB.STREAM_TYPE_ID
AND FMLT1.ID(+) = FMLB1.ID
AND FMLT1.LANGUAGE(+) = USERENV('LANG')
AND FMLB1.ID(+) = SUBB.FORMULA_ID
AND FMLT2.ID(+) = FMLB2.ID
AND FMLT2.LANGUAGE(+) = USERENV('LANG')
AND FMLB2.ID(+) = SUBB.REFUND_FORMULA_ID
AND FLK1.LOOKUP_TYPE(+) = 'OKL_SUBCALC_BASIS'
AND FLK1.LOOKUP_CODE(+) = SUBB.SUBSIDY_CALC_BASIS
AND FLK2.LOOKUP_TYPE(+) = 'OKL_SUBACCT_METHOD'
AND FLK2.LOOKUP_CODE(+) = SUBB.ACCOUNTING_METHOD_CODE
AND FLK3.LOOKUP_TYPE(+) = 'YES_NO'
AND FLK3.LOOKUP_CODE(+) = SUBB.RECOURSE_YN
AND FLK4.LOOKUP_TYPE(+) = 'OKL_SUBRFND_BASIS'
AND FLK4.LOOKUP_CODE(+) = SUBB.TERMINATION_REFUND_BASIS
AND FLK5.LOOKUP_TYPE(+) = 'OKL_SUBRCPT_METHOD'
AND FLK5.LOOKUP_CODE(+) = SUBB.RECEIPT_METHOD_CODE
AND FLK6.LOOKUP_TYPE(+) = 'YES_NO'
AND FLK6.LOOKUP_CODE(+) = SUBB.CUSTOMER_VISIBLE_YN
AND POV.VENDOR_ID(+) = SUBB.VENDOR_ID
AND FLK7.LOOKUP_TYPE (+) = 'OKL_SUBSIDY_POOL_STATUS'
AND FLK7.LOOKUP_CODE (+) = SUBP.DECISION_STATUS_CODE
AND SUBP.ID(+) = SUBB.SUBSIDY_POOL_ID

Columns