ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720451A9E05362FB09050512 Select a.ORGANIZATION_ID, a.ASSIGNMENT_ID, a.PERSON_ID, a.ELEMENT_TYPE_ID, a.SCHEDULE_BEGIN_DATE, a.SCHEDULE_END_DATE, b.GL_CODE_COMBINATION_ID, b.PROJECT_ID, b.EXPENDITURE_ORGANIZATION_ID, b.EXPENDITURE_TYPE, b.TASK_ID, b.AWARD_ID, b.SCHEDULE_BEGIN_DATE DEFAULT_BEGIN_DATE, b.SCHEDULE_END_DATE DEFAULT_END_DATE, PSP_PSPLSODL_XMLP_PKG.cf_organization_nameformula(a.ORGANIZATION_ID) CF_ORGANIZATION_NAME, PSP_PSPLSODL_XMLP_PKG.cf_gl_accountformula(b.GL_CODE_COMBINATION_ID) CF_GL_ACCOUNT, PSP_PSPLSODL_XMLP_PKG.cf_project_nameformula(b.PROJECT_ID) CF_PROJECT_NAME, PSP_PSPLSODL_XMLP_PKG.cf_task_nameformula(b.TASK_ID, b.PROJECT_ID) CF_Task_Name, PSP_PSPLSODL_XMLP_PKG.cf_award_nameformula(b.AWARD_ID) CF_Award_Name, PSP_PSPLSODL_XMLP_PKG.cf_exp_org_nameformula(b.EXPENDITURE_ORGANIZATION_ID) CF_EXP_ORG_NAME, PSP_PSPLSODL_XMLP_PKG.cf_default_begin_dateformula(b.SCHEDULE_BEGIN_DATE, :CF_date_format) CF_default_begin_date, PSP_PSPLSODL_XMLP_PKG.cf_default_end_dateformula(b.SCHEDULE_END_DATE, :CF_date_format) CF_default_end_date, PSP_PSPLSODL_XMLP_PKG.cf_earnings_elementformula(a.ELEMENT_TYPE_ID) CF_EARNINGS_ELEMENT, PSP_PSPLSODL_XMLP_PKG.cf_employee_idformula(a.PERSON_ID) CF_EMPLOYEE_ID, PSP_PSPLSODL_XMLP_PKG.cf_person_nameformula(a.PERSON_ID) CF_Person_Name, PSP_PSPLSODL_XMLP_PKG.cf_assignment_numberformula(a.ASSIGNMENT_ID, a.PERSON_ID) CF_Assignment_Number, PSP_PSPLSODL_XMLP_PKG.cf_schedule_begin_dateformula(a.SCHEDULE_BEGIN_DATE, :CF_date_format, a.SCHEDULE_END_DATE) CF_schedule_begin_date, PSP_PSPLSODL_XMLP_PKG.cf_schedule_end_dateformula(a.SCHEDULE_END_DATE, :CF_date_format) CF_schedule_end_date, PSP_PSPLSODL_XMLP_PKG.cf_number_working_daysformula(a.SCHEDULE_BEGIN_DATE, a.SCHEDULE_END_DATE) CF_NUMBER_WORKING_DAYS from PSP_REP_ORG_DLS a, PSP_DEFAULT_LABOR_SCHEDULES b where a.ORG_DLS_BATCH_ID = :P_BATCH_ID1 and a.SCHEDULE_LINE_ID = b.ORG_SCHEDULE_ID and b.business_group_id = :P_BUSINESS_GROUP_ID and b.set_of_books_id = :P_SET_OF_BOOKS_ID group by a.ORGANIZATION_ID, b.GL_CODE_COMBINATION_ID, b.PROJECT_ID, b.EXPENDITURE_ORGANIZATION_ID, b.EXPENDITURE_TYPE, b.TASK_ID, b.AWARD_ID, b.SCHEDULE_BEGIN_DATE, b.SCHEDULE_END_DATE, a.ELEMENT_TYPE_ID, a.PERSON_ID, a.ASSIGNMENT_ID, a.SCHEDULE_BEGIN_DATE, a.SCHEDULE_END_DATE order by 15, 16, 17, 18, 19, 20, 10, 13, 14, 23, 24, 25, 26, 27, 28, 29 Y PSP PSPLSODL_XML PTB PSP Relatório da Programação de Mão de Obra Padrão no Nível da Organização Imported from BI Publisher Description: Relatório de Programação de Mão de Obra Padrão do Nível de Organização Application: Distribuição da Mão de Obra Source: PSP: Relatório da Programação de Mão de Obra Padrão no Nível da Organização (XML) Short Name: PSPLSODL_XML DB package: PSP_PSPLSODL_XMLP_PKG US PSP Organization Level Default Labor Schedule Imported from BI Publisher Description: Organization Level Default Labor Schedule Report Application: Labor Distribution Source: PSP: Organization Level Default Labor Schedule Report (XML) Short Name: PSPLSODL_XML DB package: PSP_PSPLSODL_XMLP_PKG BI Publisher :cf_date_format :p_batch_id :p_batch_id1 :p_begin_date :p_business_group_id :p_conc_request_id :p_end_date :p_org_template_id :p_set_of_books_id 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 Conjunto de Livros US P_SET_OF_BOOKS_ID Set of Books 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 Org 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_begin_date Date Y PTB Data Inicial Data Inicial US Begin Date Begin Date 6 30 :p_end_date Date Y PTB Data Final Data Final US End Date End Date :$flex$.psp_report_type PSP_REPORT_TYPE Organization Set