Wednesday, March 27, 2013

Validate Accounting Segment

Your Ad Here



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
Your Ad Here

5 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. 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
  3. They will also approach your business with a fresh perspective; something a business owner can often struggle to do. Online accountants

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

    ReplyDelete
  5. 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