PA Generate Cross Charge Accounting Events

Description
Categories: BI Publisher
Application: Projects
Source: PRC: Generate Cross Charge Accounting Events (XML)
Short Name: PACCSLAR_XML
DB package: PA_PACCGLTR_XMLP_PKG
Run PA Generate Cross Charge Accounting Events and other Oracle EBS reports with Blitz Report™ on our demo environment
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
 
Char
To Project
 
Char
End GL Date
 
Date
Generate Report
 
LOV Oracle
Debug Mode
 
Char
Blitz Report™