ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720251A9E05362FB09050512Y SELECT a.PAYROLL_ID, a.TIME_PERIOD_ID, a.PERSON_ID, a.ASSIGNMENT_ID, a.ELEMENT_TYPE_ID, SUM(a.DISTRIBUTION_AMOUNT) DISTRIBUTION_AMOUNT, a.SUSPENSE_REASON_CODE, a.ORGANIZATION_ID, a.ACTUAL_PROJECT_ID, a.ACTUAL_EXP_ORG_ID, a.ACTUAL_EXPENDITURE_TYPE, a.ACTUAL_TASK_ID, a.ACTUAL_AWARD_ID, a.ACTUAL_GL_CCID, a.DISTRIBUTION_DATE, a.PROJECT_ID, a.EXPENDITURE_ORGANIZATION_ID, a.EXPENDITURE_TYPE, a.TASK_ID, a.AWARD_ID, a.GL_CODE_COMBINATION_ID, a.currency_code, PSP_PSPLDSSA_XMLP_PKG.cf_person_nameformula(a.PERSON_ID) CF_PERSON_NAME, --PSP_PSPLDSSA_XMLP_PKG.cf_employee_numberformula(a.PERSON_ID) CF_EMPLOYEE_NUMBER, PSP_PSPLDSSA_XMLP_PKG.cf_assignment_numberformula(a.ASSIGNMENT_ID) CF_ASSIGNMENT_NUMBER, PSP_PSPLDSSA_XMLP_PKG.cf_element_nameformula(a.ELEMENT_TYPE_ID) CF_ELEMENT_NAME, PSP_PSPLDSSA_XMLP_PKG.cf_gl_code_combination_idformu(a.GL_CODE_COMBINATION_ID,a.PROJECT_ID,a.TASK_ID,a.AWARD_ID,a.EXPENDITURE_ORGANIZATION_ID,a.EXPENDITURE_TYPE) CF_GL_CODE_COMBINATION_ID, PSP_PSPLDSSA_XMLP_PKG.CF_PERIOD_NAMEFORMULA(a.TIME_PERIOD_ID,a.PAYROLL_ID) CF_PERIOD_NAME, PSP_PSPLDSSA_XMLP_PKG.CF_ORGANIZATION_NAMEFORMULA(a.ORGANIZATION_ID) CF_ORGANIZATION_NAME, PSP_PSPLDSSA_XMLP_PKG.CF_ACTUAL_GL_CCIDFORMULA(a.ACTUAL_GL_CCID,a.ACTUAL_PROJECT_ID,a.ACTUAL_TASK_ID,a.ACTUAL_AWARD_ID,a.ACTUAL_EXP_ORG_ID,a.ACTUAL_EXPENDITURE_TYPE) CF_ACTUAL_GL_CCID ,PSP_PSPLDSSA_XMLP_PKG.CF_sum_currencyFormula(a.currency_code) CF_SUM_CURRENCY ,PSP_PSPLDSSA_XMLP_PKG.CF_CURRENCY_FORMATFORMULA(a.currency_code) CF_CURRENCY_FORMAT FROM PSP_REP_SSP_CHG1_V a WHERE (a.DISTRIBUTION_DATE between :P_TIME_PERIOD_START and :P_TIME_PERIOD_END) &P_ORGANIZATION_ID AND a.business_group_id = :P_BUSINESS_GROUP_ID AND a.set_of_books_id = :P_SET_OF_BOOKS_ID GROUP BY a.ORGANIZATION_ID, a.PAYROLL_ID, a.TIME_PERIOD_ID, a.ACTUAL_PROJECT_ID, a.ACTUAL_EXP_ORG_ID, a.ACTUAL_EXPENDITURE_TYPE, a.ACTUAL_TASK_ID, a.ACTUAL_AWARD_ID, a.ACTUAL_GL_CCID, a.PERSON_ID, a.ASSIGNMENT_ID, a.ELEMENT_TYPE_ID, a.PROJECT_ID, a.EXPENDITURE_ORGANIZATION_ID, a.EXPENDITURE_TYPE, a.TASK_ID, a.AWARD_ID, a.GL_CODE_COMBINATION_ID, a.DISTRIBUTION_DATE, a.SUSPENSE_REASON_CODE, a.currency_code --ORDER BY 22 ASC,7 ASC,16 ASC,17 --ASC,18 ASC,19 ASC,20 ASC,21 ASC ORDER BY CF_ORGANIZATION_NAME,a.currency_code,CF_ACTUAL_GL_CCID,CF_PERIOD_NAME,CF_ASSIGNMENT_NUMBER,CF_ELEMENT_NAME, CF_PERIOD_NAME,CF_GL_CODE_COMBINATION_ID,a.SUSPENSE_REASON_CODE,a.PROJECT_ID,a.EXPENDITURE_ORGANIZATION_ID, a.EXPENDITURE_TYPE, a.TASK_ID,a.AWARD_ID,a.GL_CODE_COMBINATION_ID,SUM(a.DISTRIBUTION_AMOUNT),a.DISTRIBUTION_DATE PSP PSPLDSSA_XML PTB PSP Relatório de Conta Suspensa da Classificação Contábil Imported from BI Publisher Description: Relatório de Conta Suspensa Application: Distribuição da Mão de Obra Source: PSP: Relatório de Conta Suspensa da Classificação Contábil (XML) Short Name: PSPLDSSA_XML DB package: PSP_PSPLDSSA_XMLP_PKG US PSP Distribution Suspense Account Imported from BI Publisher Description: Suspense Account Report Application: Labor Distribution Source: PSP: Distribution Suspense Account Report (XML) Short Name: PSPLDSSA_XML DB package: PSP_PSPLDSSA_XMLP_PKG BI Publisher &p_organization_id :p_business_group_id :p_conc_request_id :p_org_template_id :p_organization_id :p_set_of_books_id :p_time_period_end :p_time_period_start 1 -40 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') PTB P_BUSINESS_GROUP_ID Id do Grupo Funcional US P_BUSINESS_GROUP_ID Business Group Id 2 -30 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') PTB P_SET_OF_BOOKS_ID Id do Razão US P_SET_OF_BOOKS_ID Ledger Id 3 -20 :p_org_param_type Char ORG_SET PTB PSP_REPORT_TYPE Tipo de Parâmetro da Organização US PSP_REPORT_TYPE Organization Parameter Type 4 10 :p_org_template_id LOV Oracle PSP_REPORT_TEMPLATE_NAME Y select template_id id, template_name value, null description from psp_report_templates where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and report_type=:$flex$.psp_report_type order by value,description PTB Conjunto de Organizações Conjunto de Parâmetros da Organização US Organization Set Organization Parameter Set 5 20 :p_time_period_start Date Y PTB Data Inicial Data Inicial US Begin Date Begin Date 6 30 :p_time_period_end Date Y PTB Data Final Data Final US End Date End Date