PA Generate Cross Charge Accounting Events

Description
Categories: BI Publisher, Financials
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
Debug Mode
 
Generate Report
 
LOV Oracle
End GL Date
 
Date
To Project
 
From Project
 
Expenditure Batch
 
LOV Oracle
Process Category
 
LOV Oracle