ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720351A9E05362FB09050512Y SELECT psh.assignment_id sch_assignment_id, psl.schedule_hierarchy_id Hierarchy, psl.schedule_begin_date, psl.schedule_end_date, psl.schedule_percent, psh.assignment_id Type, psh.scheduling_types_code, psl.gl_code_combination_id, psl.project_id, psl.expenditure_organization_id, psl.expenditure_type, psl.task_id, psl.award_id, 1 row_ind ,PSP_PSPLSEMP_XMLP_PKG.CF_DESCRIPTIONFORMULA(psh.assignment_id,psh.scheduling_types_code) CF_DESCRIPTION ,PSP_PSPLSEMP_XMLP_PKG.CF_HIER_DESCFORMULA(psh.scheduling_types_code,PSP_PSPLSEMP_XMLP_PKG.CF_DESCRIPTIONFORMULA(psh.assignment_id,psh.scheduling_types_code)) CF_HIER_DESC ,PSP_PSPLSEMP_XMLP_PKG.CF_SCH_BEGIN_DATE_DISPFORMULA(psl.schedule_begin_date,:CF_DATE_FORMAT) CF_SCH_BEGIN_DATE_DISP ,PSP_PSPLSEMP_XMLP_PKG.CF_SCH_END_DATE_DSPFORMULA(psl.schedule_end_date,:CF_DATE_FORMAT) CF_SCH_END_DATE_DISP ,PSP_PSPLSEMP_XMLP_PKG.CF_GL_DESCRIPTIONFORMULA(psl.gl_code_combination_id) CF_GL_DESCRIPTION ,PSP_PSPLSEMP_XMLP_PKG.CF_PROJECT_NUMBERFORMULA(psl.project_id) CF_PROJECT_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_TASK_NUMBERFORMULA(psl.task_id) CF_TASK_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_AWARD_NUMBERFORMULA(psl.award_id) CF_AWARD_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_EXP_ORG_NAMEFORMULA(psl.expenditure_organization_id) CF_EXP_ORG_NAME FROM psp_schedule_hierarchy psh, psp_schedule_lines psl WHERE psl.schedule_hierarchy_id = psh.schedule_hierarchy_id AND psh.scheduling_types_code = 'A' AND psl.schedule_begin_date <= :p_end_date AND psl.schedule_end_date >= :p_begin_date AND psl.business_group_id = :p_business_group_id AND psl.set_of_books_id = :p_set_of_books_id and psh.assignment_id=:assignment_id UNION ALL SELECT psh.assignment_id sch_assignment_id, psl.schedule_hierarchy_id Hierarchy, psl.schedule_begin_date, psl.schedule_end_date, psl.schedule_percent, peg.element_group_id Type, psh.scheduling_types_code, psl.gl_code_combination_id, psl.project_id, psl.expenditure_organization_id, psl.expenditure_type, psl.task_id, psl.award_id, 1 row_ind ,PSP_PSPLSEMP_XMLP_PKG.CF_DESCRIPTIONFORMULA(peg.element_group_id,psh.scheduling_types_code) CF_DESCRIPTION ,PSP_PSPLSEMP_XMLP_PKG.CF_HIER_DESCFORMULA(psh.scheduling_types_code,PSP_PSPLSEMP_XMLP_PKG.CF_DESCRIPTIONFORMULA(peg.element_group_id,psh.scheduling_types_code)) CF_HIER_DESC ,PSP_PSPLSEMP_XMLP_PKG.CF_SCH_BEGIN_DATE_DISPFORMULA(psl.schedule_begin_date,:CF_DATE_FORMAT) CF_SCH_BEGIN_DATE_DISP ,PSP_PSPLSEMP_XMLP_PKG.CF_SCH_END_DATE_DSPFORMULA(psl.schedule_end_date,:CF_DATE_FORMAT) CF_SCH_END_DATE_DISP ,PSP_PSPLSEMP_XMLP_PKG.CF_GL_DESCRIPTIONFORMULA(psl.gl_code_combination_id) CF_GL_DESCRIPTION ,PSP_PSPLSEMP_XMLP_PKG.CF_PROJECT_NUMBERFORMULA(psl.project_id) CF_PROJECT_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_TASK_NUMBERFORMULA(psl.task_id) CF_TASK_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_AWARD_NUMBERFORMULA(psl.award_id) CF_AWARD_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_EXP_ORG_NAMEFORMULA(psl.expenditure_organization_id) CF_EXP_ORG_NAME FROM psp_schedule_hierarchy psh, psp_schedule_lines psl, psp_element_groups peg WHERE psl.schedule_hierarchy_id = psh.schedule_hierarchy_id AND psh.element_group_id = peg.element_group_id AND psh.scheduling_types_code = 'EG' AND psl.schedule_begin_date <= :p_end_date AND psl.schedule_end_date >= :p_begin_date AND psl.business_group_id = :p_business_group_id AND psl.set_of_books_id = :p_set_of_books_id AND peg.business_group_id = :p_business_group_id AND peg.set_of_books_id = :p_set_of_books_id and psh.assignment_id=:assignment_id UNION ALL SELECT psh.assignment_id sch_assignment_id, psl.schedule_hierarchy_id Hierarchy, psl.schedule_begin_date, psl.schedule_end_date, psl.schedule_percent, pet.element_type_id Type, psh.scheduling_types_code, psl.gl_code_combination_id, psl.project_id, psl.expenditure_organization_id, psl.expenditure_type, psl.task_id, psl.award_id, 1 row_ind ,PSP_PSPLSEMP_XMLP_PKG.CF_DESCRIPTIONFORMULA(pet.element_type_id,psh.scheduling_types_code) CF_DESCRIPTION ,PSP_PSPLSEMP_XMLP_PKG.CF_HIER_DESCFORMULA(psh.scheduling_types_code,PSP_PSPLSEMP_XMLP_PKG.CF_DESCRIPTIONFORMULA(pet.element_type_id,psh.scheduling_types_code)) CF_HIER_DESC ,PSP_PSPLSEMP_XMLP_PKG.CF_SCH_BEGIN_DATE_DISPFORMULA(psl.schedule_begin_date,:CF_DATE_FORMAT) CF_SCH_BEGIN_DATE_DISP ,PSP_PSPLSEMP_XMLP_PKG.CF_SCH_END_DATE_DSPFORMULA(psl.schedule_end_date,:CF_DATE_FORMAT) CF_SCH_END_DATE_DISP ,PSP_PSPLSEMP_XMLP_PKG.CF_GL_DESCRIPTIONFORMULA(psl.gl_code_combination_id) CF_GL_DESCRIPTION ,PSP_PSPLSEMP_XMLP_PKG.CF_PROJECT_NUMBERFORMULA(psl.project_id) CF_PROJECT_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_TASK_NUMBERFORMULA(psl.task_id) CF_TASK_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_AWARD_NUMBERFORMULA(psl.award_id) CF_AWARD_NUMBER ,PSP_PSPLSEMP_XMLP_PKG.CF_EXP_ORG_NAMEFORMULA(psl.expenditure_organization_id) CF_EXP_ORG_NAME FROM psp_schedule_hierarchy psh, psp_schedule_lines psl, psp_element_types_v pet WHERE psl.schedule_hierarchy_id = psh.schedule_hierarchy_id AND psh.element_type_id = pet.element_type_id AND psh.scheduling_types_code = 'ET' AND psl.schedule_begin_date <= :p_end_date AND psl.schedule_end_date >= :p_begin_date AND psl.business_group_id = :p_business_group_id AND psl.set_of_books_id = :p_set_of_books_id AND pet.business_group_id = :p_business_group_id AND pet.set_of_books_id = :p_set_of_books_id and psh.assignment_id=:assignment_id --ORDER BY 1, 2, 3, 4 ORDER BY 1 ASC,6 ASC,2 ASC,7 ASC , 1 , 2 , 3 , 4 PSP PSPLSEMP_XML PTB PSP Relatório da Programação de Mão de Obra do Funcionário Imported from BI Publisher Description: Relatório da Programação de Mão de Obra do Funcionário Application: Distribuição da Mão de Obra Source: PSP: Relatório da Programação de Mão de Obra do Funcionário (XML) Short Name: PSPLSEMP_XML DB package: PSP_PSPLSEMP_XMLP_PKG US PSP Employee Labor Schedule Imported from BI Publisher Description: Employee Labor Schedule Report Application: Labor Distribution Source: PSP: Employee Labor Schedule Report (XML) Short Name: PSPLSEMP_XML DB package: PSP_PSPLSEMP_XMLP_PKG BI Publisher :assignment_id :cf_date_format :p_begin_date :p_business_group_id :p_conc_request_id :p_end_date :p_org_template_id :p_organization_id :p_report_type :p_run_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 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 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_report_type LOV Oracle PSP_SCHEDULE_REPORT_TYPE Y select lookup_code id, lookup_code value, meaning description from psp_lookups where lookup_type='PSP_SCH_REPORT_TYPE' order by value,description Y PTB Tipo de Relatório Tipo de Relatório Normal/Exceção US Report Type Report Type Regular/Exception 6 30 :p_begin_date Date Y PTB Data Inicial Data Inicial US Begin Date Begin Date 7 40 :p_end_date Date Y PTB Data Final Data Final US End Date End Date