Wednesday, March 27, 2013

Validate Accounting Segment

INTO lc_segment1
FROM gl_sets_of_books GSOB, fnd_id_flex_structures_vl FIFST, fnd_id_flex_segments_vl FIFSE, fnd_flex_value_sets FFVS, fnd_flex_values_vl FFV WHERE GSOB.chart_of_accounts_id = FIFST.id_flex_num
AND FIFST.id_flex_num = FIFSE.id_flex_num
AND FIFST.id_flex_code = FIFSE.id_flex_code
AND FIFSE.flex_value_set_id = FFVS.flex_value_set_id
AND FFVS.flex_value_set_id = FFV.flex_value_set_id
AND FIFSE.application_column_name = 'SEGMENT1'
AND FFV.flex_value = -- Company Segment Value
AND GSOB.set_of_books_id = lc_sob_id; -- Ledger ID


  1. Alongside clearing the way for financially savvy arrangements, proficient business bookkeeping administrations suppliers additionally guarantee the craved returns and results inside tight due dates and time structures. this content

  2. They will also approach your business with a fresh perspective; something a business owner can often struggle to do. Online accountants

  3. Here at this site really the fastidious material collection so that everybody can enjoy a lot.
    Singapore Shelf Companies

  4. This is a good read i have done today so far, I am delighted to came across it. I'll be back again to check out other posts as well. Prize Bond Schedule

  5. I am definitely enjoying your website. You definitely have some great insight and great stories. KCA


Note: Only a member of this blog may post a comment.