Search 800 + Posts
Jan 18, 2016
Query to Extract GL ledger and Period details
SELECT
ledger_id,
period_set_name,
accounted_period_type,
future_enterable_periods_limit,
latest_opened_period_name,
number_per_fiscal_year
FROM
gl_ledgers, gl_period_types
WHERE
name = 'Vision Operations (USA)'
and accounted_period_type = period_type
SELECT
period_name,
period_num,
quarter_num,
period_year,
period_type,
adjustment_period_flag,
to_char(start_date,'DD-MON-YYYY') start_dt,
to_char(end_date,'DD-MON-YYYY') end_dt,
to_char(quarter_start_date,'DD-MON-YYYY') qrt_sd,
to_char(year_start_date,'DD-MON-YYYY') yr_sd
FROM
gl_periods
WHERE
period_year ='2016'
and period_set_name = '&Enter_Period_Set_name'
ORDER BY
period_type,
period_year,
period_num
SELECT
application_id,
period_name,
period_num,
quarter_num,
period_year,
closing_status,
period_type,
adjustment_period_flag,
to_char(start_date,'DD-MON-YYYY') start_dt,
to_char(end_date,'DD-MON-YYYY') end_dt,
to_char( quarter_start_date,'DD-MON-YYYY') qrt_sd,
to_char(year_start_date,'DD-MON-YYYY') yr_sd,
effective_period_num
FROM
gl_period_statuses
WHERE
period_year = '2016'
and set_of_books_id = &ledger_id
and period_year = 2016
ORDER BY
application_id,
period_type,
period_year,
period_num
Subscribe to:
Post Comments (Atom)
I am glad to find your impressive way of writing the post.Thanks for sharing the post.Also
ReplyDeletesee my blog spot cash on credit card in chennai
Good post....thanks for sharing.Do you need cash loan against credit card?.Swipe Your Credit Card And have Immediate cash With Cheapest Costs. Provide Your ID Card Photo Copy As A Document Resistant.Kindly see my blog
ReplyDeletecash against credit card chennai at low interest