PA Generate Cross Charge Accounting Events

Description
Categories: BI Publisher
Columns: Gl Category, Rejection Reason, Account Id, Pa Date, Gl Date, Dist Count, D Cur, Entered Dr, Entered Cr, A Cur ...
Application: Projects
Source: PRC: Generate Cross Charge Accounting Events (XML)
Short Name: PACCSLAR_XML
DB package: PA_PACCGLTR_XMLP_PKG
SELECT   plk2.meaning gl_category,
                 plk1.meaning rejection_reason,
                 pdls.code_combination_id account_id,  
                 pdls.pa_date pa_date, 
                 pdls.gl_date gl_date, 
                 pdls.number_of_lines dist_count, 
                 pdls.denom_tp_currency_code d_cur, 
                 pdls.entered_dr  entered_dr, 
                 pdls.entered_cr  entered_cr, 
                 pdls.ACCT_CURRENCY_CODE a_cur, 
                 pdls.accounted_dr  accounted_dr, 
                 pdls.accounted_cr  accounted_cr, 
	PA_PACCGLTR_XMLP_PKG.cf_account_idformula(pdls.code_combination_id) CF_account_id
FROM
             pa_cc_dist_lines_summarize_v pdls,  
             pa_lookups  plk1,
             pa_lookups plk2
WHERE 
              pdls.transfer_rejection_code=plk1.lookup_code
    AND  plk1.lookup_type='TRANSFER REJECTION CODE'
    AND  pdls.transfer_status_code='R'
    AND  pdls.line_type=plk2.lookup_code
    AND  plk2.lookup_type='CC_DIST_LINE_TYPE'
    AND  pdls.request_id=fnd_global.conc_request_id
    AND  pdls.org_id = pa_moac_utils.get_current_org_id
ORDER BY  account_id,  pa_date, gl_date
Parameter Name SQL text Validation
Process Category
 
LOV Oracle
Expenditure Batch
 
LOV Oracle
From Project
 
To Project
 
End GL Date
 
Date
Generate Report
 
LOV Oracle
Debug Mode