View: OKX_AST_CAT_BKS_V

Product:	OKX - Contracts Integration
Description:	Cost and reserve accounts for a book and category key flexfield combination in Oracle fixed assets.
Implementation/DBA Data:	APPS.OKX_AST_CAT_BKS_V

View Text

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

Columns