Fixed Assets - EBS (MOSC)

MOSC Banner

Add new columns in cost detail report

edited Apr 27, 2016 3:43PM in Fixed Assets - EBS (MOSC) 2 commentsAnswered

Hi..

Can any one help me in adding Location, Description, PISD, Method, Life, Date Retired to standard cost detail report.

Here I am trying this ..But data is completely wrong..

SELECT

    &ACCT_FLEX_BAL_SEG                                      COMP_CODE,

    NVL(&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account)    ACCOUNT,

    &ACCT_FLEX_COST_SEG                                     COST_CTR,

    AD.Asset_Number                                         ASSET,

   

   FL.segment1 ||'-'||FL.segment2||'-'||FL.segment3||'-'||FL.segment4         LOCATION,

    AD.Description                                          DESCRIPTION,

    FB.date_placed_in_service                               PISD,

    FB.deprn_method_code                                    METHOD,

    FB.life_in_months                                       LIFE,

    FR.date_retired                                         DATE_RETIRED,

   

    NVL(SUM (DECODE (BAL.Source_Type_Code,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Fixed Assets Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center