DBA Data[Home] [Help]

APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on GL_SETS_OF_BOOKS

Line 1814: gl_sets_of_books gsb

1810: bic_measures_all bma,
1811: ra_customer_trx_all trx,
1812: ra_customer_trx_lines_all lines,
1813: ra_cust_trx_line_gl_dist_all gl,
1814: gl_sets_of_books gsb
1815: where nvl(bma.org_id,-99) = nvl(trx.org_id,-99)
1816: and trx.bill_to_customer_id = hca.cust_account_id
1817: and bma.measure_code = 'SALES'
1818: and gl.gl_date between bdt.act_period_start_date and bdt.act_period_end_date

Line 1925: gl_sets_of_books gsb

1921: bic_temp_periods bdt,
1922: bic_measures_all bma,
1923: cst_bis_margin_summary cmt,
1924: hr_organization_information hoi,
1925: gl_sets_of_books gsb
1926:
1927: where nvl(bma.org_id,-99) = nvl(cmt.org_id,-99)
1928: and bma.measure_code = 'COGS'
1929: and cmt.gl_date between bdt.act_period_start_date and