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
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
ReplyDeleteThey will also approach your business with a fresh perspective; something a business owner can often struggle to do. Online accountants
ReplyDeleteHere at this site really the fastidious material collection so that everybody can enjoy a lot.
ReplyDeleteSingapore Shelf Companies
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
ReplyDeleteI am definitely enjoying your website. You definitely have some great insight and great stories. KCA
ReplyDelete