eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_SUBSIDY_SEARCH_UV

Product:	OKL - Leasing and Finance Management
Description:	User interfacce ciew for subsidy search and subsidy advanced search
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUBB.ID ID
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION DESCRIPTION
, SUBB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SUBB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, ITM.NAME ITEM
, DECODE(RAT.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(RAT.SEGMENT1
, ' ')
, ' '))|| DECODE(RAT.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT2
, ' ')
, ' '))|| DECODE(RAT.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT3
, ' ')
, ' '))|| DECODE(RAT.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT4
, ' ')
, ' '))|| DECODE(RAT.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT5
, ' ')
, ' '))|| DECODE(RAT.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT6
, ' ')
, ' '))|| DECODE(RAT.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT7
, ' ')
, ' '))|| DECODE(RAT.SEGMENT8
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT8
, ' ')
, ' '))|| DECODE(RAT.SEGMENT9
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT9
, ' ')
, ' '))|| DECODE(RAT.SEGMENT10
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT10
, ' ')
, ' '))|| DECODE(RAT.SEGMENT11
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT11
, ' ')
, ' '))|| DECODE(RAT.SEGMENT12
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT12
, ' ')
, ' '))|| DECODE(RAT.SEGMENT13
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT13
, ' ')
, ' '))|| DECODE(RAT.SEGMENT14
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT14
, ' ')
, ' '))|| DECODE(RAT.SEGMENT15
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT15
, ' ')
, ' '))|| DECODE(RAT.SEGMENT16
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT16
, ' ')
, ' '))|| DECODE(RAT.SEGMENT17
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT17
, ' ')
, ' '))|| DECODE(RAT.SEGMENT18
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT18
, ' ')
, ' '))|| DECODE(RAT.SEGMENT19
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT19
, ' ')
, ' '))|| DECODE(RAT.SEGMENT20
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT20
, ' ')
, ' ')) TERRITORY_SHORT_NAME
, SUBP.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SUBP.ID POOL_ID
, SUBP.DECISION_STATUS_CODE DECISION_STATUS_CODE
, SUBB.ORG_ID
FROM OKL_SUBSIDIES_TL SUBT
, OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDY_CRITERIA SUC
, OKX_SYSTEM_ITEMS_V ITM
, RA_TERRITORIES RAT
, OKL_SUBSIDY_POOLS_B SUBP
WHERE SUBP.ID(+) = SUBB.SUBSIDY_POOL_ID
AND SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND SUC.SUBSIDY_ID = SUBB.ID
AND SUC.INVENTORY_ITEM_ID = ITM.ID1
AND SUC.ORGANIZATION_ID = ITM.ID2
AND SUC.SALES_TERRITORY_ID = RAT.TERRITORY_ID UNION SELECT SUBB.ID ID
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION DESCRIPTION
, SUBB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SUBB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, NULL ITEM
, NULL TERRITORY_SHORT_NAME
, SUBP.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SUBP.ID POOL_ID
, SUBP.DECISION_STATUS_CODE DECISION_STATUS_CODE
, SUBB.ORG_ID
FROM OKL_SUBSIDIES_TL SUBT
, OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDY_POOLS_B SUBP
WHERE SUBP.ID(+) = SUBB.SUBSIDY_POOL_ID
AND SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND NOT EXISTS (SELECT '1'
FROM OKL_SUBSIDY_CRITERIA SUC
WHERE SUC.SUBSIDY_ID = SUBB.ID) UNION SELECT SUBB.ID ID
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION DESCRIPTION
, SUBB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SUBB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, ITM.NAME ITEM
, NULL TERRITORY_SHORT_NAME
, SUBP.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SUBP.ID POOL_ID
, SUBP.DECISION_STATUS_CODE DECISION_STATUS_CODE
, SUBB.ORG_ID
FROM OKL_SUBSIDIES_TL SUBT
, OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDY_CRITERIA SUC
, OKX_SYSTEM_ITEMS_V ITM
, OKL_SUBSIDY_POOLS_B SUBP
WHERE SUBP.ID(+) = SUBB.SUBSIDY_POOL_ID
AND SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND SUC.SUBSIDY_ID = SUBB.ID
AND SUC.INVENTORY_ITEM_ID = ITM.ID1
AND SUC.ORGANIZATION_ID = ITM.ID2
AND NOT EXISTS (SELECT '1'
FROM OKL_SUBSIDY_CRITERIA SUC2
WHERE SUC2.SUBSIDY_ID = SUBB.ID
AND SUC2.SALES_TERRITORY_CODE IS NOT NULL) UNION SELECT SUBB.ID ID
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION DESCRIPTION
, SUBB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SUBB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, NULL ITEM
, DECODE(RAT.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(RAT.SEGMENT1
, ' ')
, ' '))|| DECODE(RAT.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT2
, ' ')
, ' '))|| DECODE(RAT.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT3
, ' ')
, ' '))|| DECODE(RAT.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT4
, ' ')
, ' '))|| DECODE(RAT.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT5
, ' ')
, ' '))|| DECODE(RAT.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT6
, ' ')
, ' '))|| DECODE(RAT.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT7
, ' ')
, ' '))|| DECODE(RAT.SEGMENT8
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT8
, ' ')
, ' '))|| DECODE(RAT.SEGMENT9
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT9
, ' ')
, ' '))|| DECODE(RAT.SEGMENT10
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT10
, ' ')
, ' '))|| DECODE(RAT.SEGMENT11
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT11
, ' ')
, ' '))|| DECODE(RAT.SEGMENT12
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT12
, ' ')
, ' '))|| DECODE(RAT.SEGMENT13
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT13
, ' ')
, ' '))|| DECODE(RAT.SEGMENT14
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT14
, ' ')
, ' '))|| DECODE(RAT.SEGMENT15
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT15
, ' ')
, ' '))|| DECODE(RAT.SEGMENT16
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT16
, ' ')
, ' '))|| DECODE(RAT.SEGMENT17
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT17
, ' ')
, ' '))|| DECODE(RAT.SEGMENT18
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT18
, ' ')
, ' '))|| DECODE(RAT.SEGMENT19
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT19
, ' ')
, ' '))|| DECODE(RAT.SEGMENT20
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT20
, ' ')
, ' ')) TERRITORY_SHORT_NAME
, SUBP.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SUBP.ID POOL_ID
, SUBP.DECISION_STATUS_CODE DECISION_STATUS_CODE
, SUBB.ORG_ID
FROM OKL_SUBSIDIES_TL SUBT
, OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDY_CRITERIA SUC
, RA_TERRITORIES RAT
, OKL_SUBSIDY_POOLS_B SUBP
WHERE SUBP.ID(+) = SUBB.SUBSIDY_POOL_ID
AND SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND SUC.SUBSIDY_ID = SUBB.ID
AND SUC.SALES_TERRITORY_ID = RAT.TERRITORY_ID
AND NOT EXISTS (SELECT '1'
FROM OKL_SUBSIDY_CRITERIA SUC2
WHERE SUC2.SUBSIDY_ID = SUBB.ID
AND SUC2.INVENTORY_ITEM_ID IS NOT NULL) UNION SELECT SUBB.ID ID
, SUBB.NAME NAME
, SUBT.SHORT_DESCRIPTION DESCRIPTION
, SUBB.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, SUBB.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, NULL ITEM
, NULL TERRITORY_SHORT_NAME
, SUBP.SUBSIDY_POOL_NAME SUBSIDY_POOL_NAME
, SUBP.ID POOL_ID
, SUBP.DECISION_STATUS_CODE DECISION_STATUS_CODE
, SUBB.ORG_ID
FROM OKL_SUBSIDIES_TL SUBT
, OKL_SUBSIDIES_B SUBB
, OKL_SUBSIDY_POOLS_B SUBP
WHERE SUBP.ID(+) = SUBB.SUBSIDY_POOL_ID
AND SUBT.ID = SUBB.ID
AND SUBT.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT '1'
FROM OKL_SUBSIDY_CRITERIA SUC
WHERE SUC.SUBSIDY_ID = SUBB.ID)
AND NOT EXISTS (SELECT '1'
FROM OKL_SUBSIDY_CRITERIA SUC2
WHERE SUC2.SUBSIDY_ID = SUBB.ID
AND SUC2.INVENTORY_ITEM_ID IS NOT NULL
AND SUC2.SALES_TERRITORY_CODE IS NOT NULL)

Columns

Name
ID
NAME
DESCRIPTION
EFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATE
ITEM
TERRITORY_SHORT_NAME
SUBSIDY_POOL_NAME
POOL_ID
DECISION_STATUS_CODE
ORG_ID