PA Release Allocations Transactions

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Release Allocations Transactions
Application: Projects
Source: PRC: Release Allocations Transactions (XML)
Short Name: PAXALRAT_XML
DB package: PA_PAXALRUN_XMLP_PKG
Run PA Release 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
Download
Related Blitz Reports
PA Generate 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 PO Receiving Transactions Pipeline XXT OF: PO Headers and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: