VIEW: APPS.OKL_SUBSIDIES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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