PA Cross Charge Audit

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: AUD: Cross Charge Audit Report
Application: Projects
Source: AUD: Cross Charge Audit Report (XML)
Short Name: PAXCCGLA_XML
DB package: PA_PAXCCGLA_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT nvl(pl.meaning, cc_dist_line_type)    gl_category,
               cst.code_combination_id,
               project_number,
               task_number,
               expenditure_type,
               expenditure_item_date,
               substr(emp_or_org_name,1,60) emp_or_org_name,               period_name,
               transferred_date,
               gl_dr_amount,
               gl_cr_amount, 
	PA_PAXCCGLA_XMLP_PKG.account_idformula(cst.code_combination_id) Account_id
FROM     PA_CC_GL_COST_XFER_AUDIT_V         cst,
               pa_lookups 		          pl,
               gl_code_combinations                          CC
WHERE   &l_where_clause    
AND        TRUNC(nvl(transferred_date,sysdate))
                    BETWEEN NVL(TRUNC(:cf_from_date), TRUNC(nvl(transferred_date,sysdate)))
                    AND NVL(TRUNC(:cf_to_date), TRUNC(nvl(transferred_date,sysdate)))
AND        CC.code_combination_id = cst.code_combination_id 
AND        pl.lookup_type = 'CC_DIST_LINE_TYPE'
AND        pl.lookup_code = NVL(:p_gl_category, pl.lookup_code)
AND        cc_dist_line_type = pl.lookup_code
AND        &cp_where
/*ORDER BY  gl_category,      
                    cst.code_combination_id,
                    project_number,
                    task_number,
                    expenditure_type,
                    expenditure_item_date*/
					ORDER BY 1 ASC,2 ASC , gl_category , cst.code_combination_id , project_number , task_number , expenditure_type , expenditure_item_date
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
GL Category 
 
 LOV Oracle
From GL Account 
 
 Char
To GL Account 
 
 Char
From GL Period 
 
 LOV Oracle
To GL Period 
 
 LOV Oracle
From Interface Date 
 
 Date
To Interface Date 
 
 Date
Download
 
Related Blitz Reports
PA Cost Audit PA Project Subledger: Detail by Project PA Project Subledger: Detail by Expenditure Type PA Task Details ECC Projects, Projects Costing: Transactions, SQL1 PA Expense Report Audit PA Project Subledger Summary CAC ICP PII WIP Material Usage Variance CAC Manufacturing Variance Summary
Blitz Report™

Blitz Report™ provides multiple benefits: