PSP Distribution Default Account

Description
Categories: BI Publisher
Columns: Organization Id, Currency Code, Project Id, Expenditure Organization Id, Expenditure Type, Task Id, Award Id, Gl Code Combination Id, Person Id, Assignment Id ...
Application: Labor Distribution
Source: PSP: Distribution Default Account Report (XML)
Short Name: PSPLDDFA_XML
DB package: PSP_PSPLDDFA_XMLP_PKG
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
P_BUSINESS_GROUP_ID
 
Number
P_SET_OF_BOOKS_ID
 
Number
PSP_REPORT_TYPE