Wednesday, March 27, 2013

Validate Accounting Segment



SELECT COUNT (1)
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 = rec_cur_new.company -- Company Segment Value
AND GSOB.set_of_books_id = lc_sob_id; -- Ledger ID

5 comments:

  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

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

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

    ReplyDelete
  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

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

    ReplyDelete

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