PA Cost Audit

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: AUD: Cost Audit Report
Application: Projects
Source: AUD: Cost Audit Report (XML)
Short Name: PAXAUGLT_XML
DB package: PA_PAXAUGLT_XMLP_PKG
Run PA Cost Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT /*+ LEADING(cc) */			
 	cst.code_combination_id,
	fnd_flex_ext.get_segs('SQLGL', 'GL#', :p_coa_id, cst.code_combination_id) Account_id,
	project_number, 
	task_number,
	SUBSTR(expenditure_type,1,22) expenditure_type, 
	expenditure_item_date, 
	SUBSTR(emp_or_org_name,1,32) emp_or_org_name,
	period_name,
	transferred_date,
	gl_dr_amount,
	gl_cr_amount,
    cr_code_combination_id,
	fnd_flex_ext.get_segs('SQLGL', 'GL#', :p_coa_id, cr_code_combination_id) CR_ACCOUNT_ID
FROM	PA_GL_COST_XFER_AUDIT_V  cst, gl_code_combinations CC
WHERE	gl_date BETWEEN nvl(:cp_gl_start, gl_date) 
AND	nvl(:cp_gl_end, gl_date)
AND	TRUNC(transferred_date)
BETWEEN nvl(:P_FROM_INTERFACE_DATE, TRUNC(transferred_date))
AND	nvl(:P_TO_INTERFACE_DATE, TRUNC(transferred_date))
AND         CC.code_combination_id = cst.code_combination_id
AND	&c_where
ORDER	BY cst.code_combination_id, project_number, task_number, expenditure_type, expenditure_item_date
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
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 Cross Charge Audit CAC Inventory Accounts Setup CAC Material Account Detail CAC ICP PII Material Account Detail CAC ICP PII Material Account Summary CAC Recost Cost of Goods Sold CAC Deferred COGS Out-of-Balance PA Capital Project Summary with Asset Detail PA Project Subledger: Detail by Project
Blitz Report™

Blitz Report™ provides multiple benefits: