View: OKL_SUBSIDY_CRITERIA_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for subsidy application criteria page
Implementation/DBA Data:	APPS.OKL_SUBSIDY_CRITERIA_UV

View Text

SELECT SUC.ID ID
, SUC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SUC.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, SUC.SUBSIDY_ID SUBSIDY_ID
, SUB.NAME SUBSIDY_NAME
, SUT.SHORT_DESCRIPTION SUBSIDY_SHORT_DESCRIPTION
, SUC.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUC.ORGANIZATION_ID INVENTORY_ORG_ID
, MSI.DESCRIPTION INVENTORY_ITEM_NAME
, MSI.CONCATENATED_SEGMENTS INVENTORY_ITEM_CODE
, ORD.ORGANIZATION_NAME INVENTORY_ORG_NAME
, ORD.ORGANIZATION_CODE INVENTORY_ORG_CODE
, SUC.CREDIT_CLASSIFICATION_CODE CREDIT_CLASSIFICATION_CODE
, ARL1.MEANING CREDIT_CLASS_MEANING
, SUC.SALES_TERRITORY_ID SALES_TERRITORY_ID
, 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_CONCAT_SEGMENTS
, RAT.NAME TERRITORY_NAME
, RAT.DESCRIPTION TERRITORY_DESCRIPTION
, SUC.PRODUCT_ID PRODUCT_ID
, PDT.NAME PRODUCT_NAME
, PDT.DESCRIPTION PRODUCT_DESCRIPTION
, SUC.INDUSTRY_CODE_TYPE INDUSTRY_CODE_TYPE
, ARL2.MEANING IND_CODE_TYPE_MEANING
, SUC.INDUSTRY_CODE INDUSTRY_CODE
, ARL3.MEANING INDUSTRY_CODE_MEANING
, SUB.CURRENCY_CODE CURRENCY_CODE
FROM OKL_SUBSIDIES_B SUB
, OKL_SUBSIDIES_TL SUT
, MTL_SYSTEM_ITEMS_B_KFV MSI
, ORG_ORGANIZATION_DEFINITIONS ORD
, RA_TERRITORIES RAT
, OKL_PRODUCTS PDT
, AR_LOOKUPS ARL1
, AR_LOOKUPS ARL2
, AR_LOOKUPS ARL3
, OKL_SUBSIDY_CRITERIA SUC
WHERE SUT.ID = SUB.ID
AND SUT.LANGUAGE = USERENV('LANG')
AND SUB.ID = SUC.SUBSIDY_ID
AND MSI.INVENTORY_ITEM_ID(+) = SUC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = SUC.ORGANIZATION_ID
AND ORD.ORGANIZATION_ID(+) = SUC.ORGANIZATION_ID
AND RAT.TERRITORY_ID(+) = SUC.SALES_TERRITORY_ID
AND PDT.ID(+) = SUC.PRODUCT_ID
AND ARL1.LOOKUP_CODE(+) = SUC.CREDIT_CLASSIFICATION_CODE
AND ARL1.LOOKUP_TYPE(+) = 'AR_CMGT_TRADE_RATINGS'
AND ARL2.LOOKUP_CODE(+) = SUC.INDUSTRY_CODE_TYPE
AND ARL2.LOOKUP_TYPE(+) = 'SIC_CODE_TYPE'
AND ARL3.LOOKUP_CODE(+) = SUC.INDUSTRY_CODE
AND ARL3.LOOKUP_TYPE(+) = SUC.INDUSTRY_CODE_TYPE

Columns