PA Interfaced CIP/RWIP Amounts by FA Period

Description
Categories: BI Publisher
Application: Projects
Source: AUD: Interfaced CIP/RWIP Amounts by FA Period Report (XML)
Short Name: PACRCIPF_XML
DB package: PA_PACRCIPF_XMLP_PKG
SELECT
       pt.project_type                         r_project_type
      ,ppa.fa_period_name                r_period_name
      ,p.segment1                               r_project_number
      ,p.name                                      r_project_name
       ,decode(:p_group_by_cat,
                     'Y',fnd_flex_ext.get_segs('OFA',
                                                                  'CAT#',
                                                                   101,
                                                                   ppa.asset_category_id),
                            ppa.asset_name)r_column_1
      ,decode(:p_group_by_cat,
                    'Y',ppa.asset_name
                         ,fnd_flex_ext.get_segs('OFA',
                                                                  'CAT#',
                                                                   101,
                                                                    ppa.asset_category_id))r_column_2
      ,pal.description                          r_description
      ,fnd_flex_ext.get_segs('SQLGL','GL#',:cp_coa_id,pal.cip_ccid)  r_cip_ccid
      ,pal.&lp_pa_curr_asset_cost	 r_current_asset_cost
      ,pal.capital_event_id                 r_capital_event_id
FROM
       &lp_pa_proj_asset_line pal,
       pa_projects p,
       pa_project_types pt,
       pa_project_assets ppa,
       gl_code_combinations cc,
       fa_deprn_periods fap
WHERE
       pal.cip_ccid=cc.code_combination_id
 AND  pal.project_id = p.project_id
  AND  pal.line_type='R'
  AND  pal.project_asset_id = ppa.project_asset_id
  AND  p.project_type = pt.project_type
  AND    pal.transfer_status_code ='T'
  AND  fap.book_type_code = ppa.book_type_code
  AND  pal.fa_period_name =fap.period_name
  AND  fap.calendar_period_open_date >= nvl(:cp_min_open_date,fap.calendar_period_open_date) /* Bug 21891438 */
  AND  NVL(fap.calendar_period_close_date,TRUNC(SYSDATE)) <=  NVL(nvl(:cp_max_close_date,fap.calendar_period_close_date),TRUNC(SYSDATE)) /*Added for bug 16816473 */
   AND     (:p_class_category IS NULL  OR
                p.project_id in ( SELECT   project_id
                                          FROM     pa_project_classes
                                          WHERE   class_category = :p_class_category) )
  AND   (:p_class_category IS NULL   OR
              :p_class_code        IS NULL   OR
               p.project_id in  ( SELECT    project_id
                                         FROM       pa_project_classes
                                         WHERE    class_category = :p_class_category
                                          AND        class_code = :p_class_code))
  AND  nvl(:p_project_type,pt.project_type)=pt.project_type
  AND  nvl(:p_project_id,p.project_id)=p.project_id
  AND  nvl (:p_project_org,p.carrying_out_organization_id)   =
            p.carrying_out_organization_id
 AND  &c_where
AND &c_sob_id
ORDER BY 2 ASC,1 ASC,3 ASC,4 ASC,5 ASC
Parameter Name SQL text Validation
From FA Period
 
LOV Oracle
To FA Period
 
LOV Oracle
From GL Account
 
To GL Account
 
Project Type
 
LOV Oracle
Project Number
 
LOV Oracle
Project Organization
 
LOV Oracle
Class Category
 
LOV Oracle
Class Code
 
LOV Oracle
Primary Sort by Asset Category?
 
LOV Oracle
Set of Books Currency
 
LOV Oracle
Chart of accounts ID
 
LOV Oracle