PA Expense Report Audit

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Expense Report Audit Report
Application: Projects
Source: AUD: Expense Report Audit Report (XML)
Short Name: PAXAUERT_XML
DB package: PA_PAXAUVIT_XMLP_PKG
Run PA Expense Report Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
            SELECT
                     p.segment1         project_number
                ,t.task_number      task_number
                ,pai.expenditure_type   expenditure_type
                ,api.invoice_date       invoice_date
                ,cdl.transferred_date       transfer_date
                ,cdl.gl_date                                    gl_date
                ,&c_select_clause                         vendor_employee_name
                ,api.invoice_num        invoice_number
                ,apid.distribution_line_number  distribution_line_number
                ,cdl.amount
                               ,cdl.dr_code_combination_id
                            ,apid.invoice_line_number         invoice_line_num,
                PA_PAXAUVIT_XMLP_PKG.account_flex_idformula(cdl.dr_code_combination_id) ACCOUNT_FLEX_ID
            FROM    pa_projects_all         p
                             ,pa_tasks          t
                             ,pa_expenditures       pae
                            ,pa_expenditure_items       pai
                            ,ap_invoices_all        api
                           ,gl_code_combinations        cc
                           ,pa_cost_distribution_lines  cdl
                           ,ap_invoice_distributions    apid
                           ,&c_from_clause
            WHERE  cdl.dr_code_combination_id=apid.dist_code_combination_id
                 AND cdl.expenditure_item_id=pai.expenditure_item_id
                 AND api.invoice_id=apid.invoice_id
                 AND to_number(cdl.system_reference2)=apid.invoice_id      AND to_number(cdl.system_reference3)=apid.distribution_line_number      AND cdl.line_type='R'
                 AND &c_where_clause
                 AND &c_where_cc
                 AND pai.task_id=t.task_id
                 AND pai.system_linkage_function=:P_report_type
                 AND pai.expenditure_id=pae.expenditure_id
                 AND t.project_id=p.project_id
                 AND cdl.transfer_status_code='V'
                 AND cdl.dr_code_combination_id=cc.code_combination_id
                 AND cdl.gl_date BETWEEN  nvl(:P_from_gl_date,cdl.gl_date) AND                             nvl(:P_to_gl_date,cdl.gl_date)
                 AND  trunc(cdl.transferred_date) BETWEEN nvl(:P_from_transfer_date,trunc(cdl.transferred_date)) AND
                            nvl(:P_to_transfer_date,trunc(cdl.transferred_date))
               ORDER BY 11 ASC , dr_code_combination_id , invoice_number , distribution_line_number
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
From GL Date 
 
 Date
To GL Date 
 
 Date
From Transfer Date 
 
 Date
To Transfer Date 
 
 Date
From GL Account 
 
 Char
To GL Account 
 
 Char
Download
 
Related Blitz Reports
PA Supplier Invoice Audit GL Account Analysis GL Account Analysis (Distributions) GMI Inventory Edit Journal GL Account Analysis (Distributions) 11g GL Account Analysis 11g AP Invoices and Lines ECC Procurement, Purchase Orders ECC Projects, Projects Costing: Transactions, SQL1
Blitz Report™

Blitz Report™ provides multiple benefits: