PA Cost Audit
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
Description: AUD: Cost Audit Report
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 | |
---|---|---|---|
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 |