Oracle Apps Technical Information

Oracle projection report concurrent request, it runs in two parts. The first part builds a table of projection info. The second part is a spawned job that prints the report.  Register a concurrent request that only runs the first part and use sql against the temporary table that is generated. -- This code assumes fadeprn_temp exists - this is a copy of any fa_proj_interim_x table -- P1 = Book -- P2 = Period DECLARE    req_id         NUMBER;     req_id1         NUMBER;    output_file    UTL_FILE.file_type;    errbuf         VARCHAR2 (240);    v_context      VARCHAR2 (100);    v_phase_code   VARCHAR2 (5);    v_stmt_str     VARCHAR2 (2000); -- Report generator    CURSOR c1    IS       SELECT      'Comp_'             ...

select * from ( SELECT DISTINCT  dhcc.segment2 business_unit, dhcc.segment3 ACCOUNT,                 dhcc.segment4 dept, dhcc.segment5, fc.concatenated_segments,fpip.DEPRECIATION,fdp.Period_name             FROM  fadeprn_temp fpip ,  fa_additions fa,                 fa_deprn_periods fdp,                 fa.fa_deprn_summary fds,                 fa_categories_b_kfv fc,                 fa_distribution_history dh,                 gl_code_combinations dhcc           WHERE fa.asset_id = fds.asset_id             AND fdp.period_counter = fds.period_counter             AND dhcc.code_combination_id(+) = dh.code_combinat...