ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471FF51A9E05362FB09050512 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 Y PSP PSPLDDFA_XML PTB PSP Relatório da Conta Padrão da Classificação Contábil Imported from BI Publisher Description: Relatório da Conta Padrão Application: Distribuição da Mão de Obra Source: PSP: Relatório da Conta Padrão da Classificação Contábil (XML) Short Name: PSPLDDFA_XML DB package: PSP_PSPLDDFA_XMLP_PKG US PSP Distribution Default Account 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 BI Publisher &p_organization_id :cf_currency_format :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_end1 :p_time_period_start :p_time_period_start1 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 :$flex$.psp_report_type PSP_REPORT_TYPE Organization Set