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.

VIEW: APPS.OKL_SUBSIDY_CRITERIA_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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