PA Cost Audit

Description
Categories: BI Publisher
Application: Projects
Source: AUD: Cost Audit Report (XML)
Short Name: PAXAUGLT_XML
DB package: PA_PAXAUGLT_XMLP_PKG
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
From GL Account
 
To GL Account
 
From GL Period
 
LOV Oracle
To GL Period
 
LOV Oracle
From Interface Date
 
Date
To Interface Date
 
Date
Set of Books Currency
 
LOV Oracle
SOB_ID
 
Number
Chart of accounts id
 
LOV Oracle