PA Cross Charge Audit

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