PA Generate Cross Charge Accounting Events

➜ Back to Library
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
Download
Related Blitz Reports
PA Project Subledger: Detail by Project PA Project Subledger: Detail by Expenditure Type PA Sweep Transaction Accounting Events ECC Projects, Projects Costing: Transactions, SQL1 PA Cross Charge Audit PA Expense Report Audit PA Project Subledger Summary JA India - Open Transactions Report for Prior-GST (XML Publisher) XLA Distribution Links Summary
Blitz Report™

Blitz Report™ provides multiple benefits: