PA Generate Allocations Transactions

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Generate Allocations Transactions
Application: Projects
Source: PRC: Generate Allocations Transactions (XML)
Short Name: PAXALGAT_XML
DB package: PA_PAXALRUN_XMLP_PKG
Run PA Generate Allocations Transactions and other Oracle EBS reports with Blitz Report™ on our demo environment
select transaction_type,project_number,project_name,count(project_number) txn_count,sum(current_allocation),sum(previous_allocation),sum(total_allocation), 
	/*PA_PAXALRUN_XMLP_PKG.c_dsp_current_sumformula(:CS_current_sum, :C_fmt_mask) C_DSP_CURRENT_SUM, 
	PA_PAXALRUN_XMLP_PKG.c_dsp_previous_sumformula(:CS_previous_sum, :C_fmt_mask) C_DSP_PREVIOUS_SUM, 
	PA_PAXALRUN_XMLP_PKG.c_dsp_tot_sumformula(:CS_tot_sum, :C_fmt_mask) C_DSP_TOT_SUM, */
	PA_PAXALRUN_XMLP_PKG.c_dsp_sum_current_allocationfo(sum(current_allocation), :C_fmt_mask) C_DSP_SUM_CURRENT_ALLOCATION, 
	PA_PAXALRUN_XMLP_PKG.c_dsp_sum_prev_allocationformu(sum(previous_allocation), :C_fmt_mask) C_DSP_SUM_PREV_ALLOCATION, 
	PA_PAXALRUN_XMLP_PKG.c_dsp_total_allocationformula(sum(total_allocation), :C_fmt_mask) C_DSP_SUM_TOTAL_ALLOCATION
from pa_alloc_transactions_v where run_id = :p_run_id group by transaction_type,project_number,project_name order by transaction_type, project_number
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Rule Name 
 
 LOV Oracle
Period Name 
 
 LOV Oracle
Expenditure Item Date 
 
 Date
Download
Related Blitz Reports
PA Release Allocations Transactions ECC Projects, Projects Costing: Transactions, SQL1 PA Generate Asset Lines for a Range of Projects ECC Cost Management, Inventory Transactions PA Generate Asset Lines for a Single Project ECC G-Invoicing, Projects: G-Invoicing PA Delete PA Periods CAC WIP Resource Efficiency CAC WIP Material Usage with Configuration and Lot Variances
Blitz Report™

Blitz Report™ provides multiple benefits: