PSP Distribution Default Account
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
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 |