VIEW: APPS.OKX_AST_CAT_BKS_V

Source

View Text - Preformatted

SELECT FCB.CATEGORY_ID ID1, FCB.BOOK_TYPE_CODE ID2, decode(FC.segment1,null,null,ltrim(rtrim(fc.segment1,' '),' '))|| decode(FC.segment2,null,null,'.'||ltrim(rtrim(fc.segment2,' '),' '))|| decode(FC.segment3,null,null,'.'||ltrim(rtrim(fc.segment3,' '),' '))|| decode(FC.segment4,null,null,'.'||ltrim(rtrim(fc.segment4,' '),' '))|| decode(FC.segment5,null,null,'.'||ltrim(rtrim(fc.segment5,' '),' '))|| decode(FC.segment6,null,null,'.'||ltrim(rtrim(fc.segment6,' '),' '))|| decode(FC.segment7,null,null,'.'||ltrim(rtrim(fc.segment7,' '),' ')) NAME, '#' DESCRIPTION, FCB.CATEGORY_ID CATEGORY_ID, FCB.BOOK_TYPE_CODE BOOK_TYPE_CODE, FCB.ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT, FCB.ASSET_COST_ACCT ASSET_COST_ACCT, FCB.CIP_CLEARING_ACCT CIP_CLEARING_ACCT, FCB.CIP_COST_ACCT CIP_COST_ACCT, FCB.DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT, FCB.DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT, FCB.REVAL_AMORTIZATION_ACCT REVAL_AMORTIZATION_ACCT, FCB.REVAL_RESERVE_ACCT REVAL_RESERVE_ACCT, FCB.ASSET_COST_ACCOUNT_CCID ASSET_COST_ACCOUNT_CCID, FCB.ASSET_CLEARING_ACCOUNT_CCID ASSET_CLEARING_ACCOUNT_CCID, FCB.WIP_COST_ACCOUNT_CCID WIP_COST_ACCOUNT_CCID, FCB.WIP_CLEARING_ACCOUNT_CCID WIP_CLEARING_ACCOUNT_CCID, FCB.RESERVE_ACCOUNT_CCID RESERVE_ACCOUNT_CCID, FCB.REVAL_AMORT_ACCOUNT_CCID REVAL_AMORT_ACCOUNT_CCID, FCB.REVAL_RESERVE_ACCOUNT_CCID REVAL_RESERVE_ACCOUNT_CCID, FCB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, FCB.LIFE_EXTENSION_CEILING LIFE_EXTENSION_CEILING, FCB.LIFE_EXTENSION_FACTOR LIFE_EXTENSION_FACTOR, FCB.DEFAULT_GROUP_ASSET_ID DEFAULT_GROUP_ASSET_ID, FCB.BONUS_DEPRN_EXPENSE_ACCT BONUS_DEPRN_EXPENSE_ACCT, FCB.BONUS_DEPRN_RESERVE_ACCT BONUS_DEPRN_RESERVE_ACCT, FCB.BONUS_RESERVE_ACCT_CCID BONUS_RESERVE_ACCT_CCID, FC.START_DATE_ACTIVE START_DATE_ACTIVE, FC.END_DATE_ACTIVE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(FC.start_date_active,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(FC.end_date_active,trunc(sysdate))), 1,'I','A')) STATUS, NULL PRIMARY_UOM_CODE FROM FA_CATEGORIES_B FC,FA_CATEGORY_BOOKS FCB WHERE FCB.CATEGORY_ID = FC.CATEGORY_ID

View Text - HTML Formatted

SELECT FCB.CATEGORY_ID ID1
, FCB.BOOK_TYPE_CODE ID2
, DECODE(FC.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(FC.SEGMENT1
, ' ')
, ' '))|| DECODE(FC.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(FC.SEGMENT2
, ' ')
, ' '))|| DECODE(FC.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(FC.SEGMENT3
, ' ')
, ' '))|| DECODE(FC.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(FC.SEGMENT4
, ' ')
, ' '))|| DECODE(FC.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(FC.SEGMENT5
, ' ')
, ' '))|| DECODE(FC.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(FC.SEGMENT6
, ' ')
, ' '))|| DECODE(FC.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(FC.SEGMENT7
, ' ')
, ' ')) NAME
, '#' DESCRIPTION
, FCB.CATEGORY_ID CATEGORY_ID
, FCB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FCB.ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT
, FCB.ASSET_COST_ACCT ASSET_COST_ACCT
, FCB.CIP_CLEARING_ACCT CIP_CLEARING_ACCT
, FCB.CIP_COST_ACCT CIP_COST_ACCT
, FCB.DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT
, FCB.DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT
, FCB.REVAL_AMORTIZATION_ACCT REVAL_AMORTIZATION_ACCT
, FCB.REVAL_RESERVE_ACCT REVAL_RESERVE_ACCT
, FCB.ASSET_COST_ACCOUNT_CCID ASSET_COST_ACCOUNT_CCID
, FCB.ASSET_CLEARING_ACCOUNT_CCID ASSET_CLEARING_ACCOUNT_CCID
, FCB.WIP_COST_ACCOUNT_CCID WIP_COST_ACCOUNT_CCID
, FCB.WIP_CLEARING_ACCOUNT_CCID WIP_CLEARING_ACCOUNT_CCID
, FCB.RESERVE_ACCOUNT_CCID RESERVE_ACCOUNT_CCID
, FCB.REVAL_AMORT_ACCOUNT_CCID REVAL_AMORT_ACCOUNT_CCID
, FCB.REVAL_RESERVE_ACCOUNT_CCID REVAL_RESERVE_ACCOUNT_CCID
, FCB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FCB.LIFE_EXTENSION_CEILING LIFE_EXTENSION_CEILING
, FCB.LIFE_EXTENSION_FACTOR LIFE_EXTENSION_FACTOR
, FCB.DEFAULT_GROUP_ASSET_ID DEFAULT_GROUP_ASSET_ID
, FCB.BONUS_DEPRN_EXPENSE_ACCT BONUS_DEPRN_EXPENSE_ACCT
, FCB.BONUS_DEPRN_RESERVE_ACCT BONUS_DEPRN_RESERVE_ACCT
, FCB.BONUS_RESERVE_ACCT_CCID BONUS_RESERVE_ACCT_CCID
, FC.START_DATE_ACTIVE START_DATE_ACTIVE
, FC.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(FC.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(FC.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
FROM FA_CATEGORIES_B FC
, FA_CATEGORY_BOOKS FCB
WHERE FCB.CATEGORY_ID = FC.CATEGORY_ID