Oracle Applications

Oracle for Beginners

View for Chart of Accounts KFF

Posted by shameemakhtar on October 19, 2009

The script below allows you creates a view for your chart of accounts.
Modify to suit your requirements. Note that the value set name of each segment is passed as parameter.

CREATE OR REPLACE VIEW ABH_GL_ACC_CONCAT_SEGMENTS
AS
SELECT cc.code_combination_id,
 cc.chart_of_accounts_id,
 cc.detail_posting_allowed_flag post,
 cc.detail_budgeting_allowed_flag budget,
 cc.account_type,
 cc.show_account_type,
 cc.enabled_flag,
 cc.summary_flag,
 --segment: segments used in COA definition
 cc.segment1,
 cc.segment2,
 cc.segment3,
 cc.segment4,
 cc.segment5,
 cc.segment6,
 concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(segment1, '-'), segment2),'-'), segment3), '-'), segment4), '-'), segment5), '-'), segment6) account_comb,
 get_flex_vs_desc('ABH Company', cc.segment1, '') Company,
 get_flex_vs_desc('ABH Cost Center', cc.segment2, '') "Cost Center",
 get_flex_vs_desc('ABH Account', cc.segment3, '') "Account",
 get_flex_vs_desc('ABH Sub Account', cc.segment4, cc.segment3) "Sub Account",
 get_flex_vs_desc('ABH Location', cc.segment5, '') "Location",
 get_flex_vs_desc('ABH Entity-Services', cc.segment6, '') "Entity-Services"
FROM GL_CODE_COMBINATIONS_V cc

Refer to document ‘Fetching Key Flexfield Value Description‘ for get_flex_vs_desc.
Shameem Bauccha

19 October 2009

Advertisements

3 Responses to “View for Chart of Accounts KFF”

  1. […] View for Chart of Accounts KFF […]

  2. […] View for Chart of Accounts KFF […]

  3. Fantastic beat ! I would like to apprentice whilst you amend your web site, how can i subscribe for a weblog website?

    The account helped me a acceptable deal. I had been a little bit acquainted of this
    your broadcast offered vivid transparent idea

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s