PSP Distribution Default Account

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Default Account Report
Application: Labor Distribution
Source: PSP: Distribution Default Account Report (XML)
Short Name: PSPLDDFA_XML
DB package: PSP_PSPLDDFA_XMLP_PKG
Run PSP Distribution Default Account and other Oracle EBS reports with Blitz Report™ on our demo environment
select ORGANIZATION_ID,
CURRENCY_CODE,
PROJECT_ID,
EXPENDITURE_ORGANIZATION_ID,
EXPENDITURE_TYPE,
TASK_ID,
AWARD_ID,
GL_CODE_COMBINATION_ID,
PERSON_ID,
ASSIGNMENT_ID,
ELEMENT_TYPE_ID,
PAYROLL_ID,
TIME_PERIOD_ID,
sum(DISTRIBUTION_AMOUNT) DISTRIBUTION_AMOUNT,
DEFAULT_REASON_CODE,
DEFAULT_ORG_ACCOUNT_ID,
BUSINESS_GROUP_ID,
SET_OF_BOOKS_ID,
	PSP_PSPLDDFA_XMLP_PKG.cf_organization_nameformula(ORGANIZATION_ID) CF_ORGANIZATION_NAME,
	PSP_PSPLDDFA_XMLP_PKG.cf_sum_currencyformula(CURRENCY_CODE) CF_sum_currency,
	PSP_PSPLDDFA_XMLP_PKG.cf_currency_formatformula(CURRENCY_CODE) CF_currency_format,
	/*PSP_PSPLDDFA_XMLP_PKG.cf_sum_distribution_amountform(:CF_currency_format, :CS_distribution_amount) CF_sum_distribution_amount, */
	PSP_PSPLDDFA_XMLP_PKG.cf_charging_instructionsformul(GL_CODE_COMBINATION_ID, PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE) CF_charging_instructions,
	PSP_PSPLDDFA_XMLP_PKG.cf_person_nameformula(PERSON_ID) CF_PERSON_NAME,
	PSP_PSPLDDFA_XMLP_PKG.cf_assignment_numberformula(ASSIGNMENT_ID) CF_ASSIGNMENT_NUMBER,
	PSP_PSPLDDFA_XMLP_PKG.cf_element_nameformula(ELEMENT_TYPE_ID) CF_ELEMENT_NAME,
	PSP_PSPLDDFA_XMLP_PKG.cf_period_nameformula(TIME_PERIOD_ID) CF_Period_Name,
	PSP_PSPLDDFA_XMLP_PKG.cf_distribution_amount_dspform(sum ( DISTRIBUTION_AMOUNT ), :CF_currency_format) CF_distribution_amount_dsp
from PSP_REP_DEF_CHG_V
where (DISTRIBUTION_DATE between :P_TIME_PERIOD_START1 and :P_TIME_PERIOD_END1)
 &P_ORGANIZATION_ID
and business_group_id = :P_BUSINESS_GROUP_ID
and set_of_books_id = :P_SET_OF_BOOKS_ID
group by ORGANIZATION_ID,
CURRENCY_CODE,
PROJECT_ID,
EXPENDITURE_ORGANIZATION_ID,
EXPENDITURE_TYPE,
TASK_ID,
AWARD_ID,
GL_CODE_COMBINATION_ID,
PERSON_ID,
ASSIGNMENT_ID,
ELEMENT_TYPE_ID,
PAYROLL_ID,
TIME_PERIOD_ID,
DEFAULT_REASON_CODE,
DEFAULT_ORG_ACCOUNT_ID,
BUSINESS_GROUP_ID,
SET_OF_BOOKS_ID
Parameter Name SQL text Validation
Organization Set 
 
 LOV Oracle
Begin Date 
 
 Date
End Date 
 
 Date
Download
Related Blitz Reports
ZX Tax Regimes PSP Distribution Suspense Account JE Italian Annual Supplier Listing JE Portuguese Suppliers Recapitulative JG EMEA VAT: Turnover AP Non TRL Extract ZX Tax Reconciliation by Taxable Account Report- Not Supported: Reserved For Future Use WIP Repetitive Schedule Data ECC Procurement, Purchase Orders PO IDV Modification
Blitz Report™

Blitz Report™ provides multiple benefits: