ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720851A9E05362FB09050512Y SELECT sum(DECODE(ppl.dr_cr_flag, 'C', pdl.distribution_amount, 0)) DL_Credit_Amount, sum(DECODE(ppl.dr_cr_flag, 'D', pdl.distribution_amount, 0)) DL_Debit_Amount, to_char(min(pdl.distribution_date), 'DD-MON-YYYY') CI_Begin_date, to_char(max(pdl.distribution_date),'DD-MON-YYYY') CI_End_Date, DECODE(pdl.gl_project_flag, 'G', DECODE(pdl.suspense_org_Account_id, NULL, nvl(pdl.auto_gl_code_combination_id, nvl(pdl.cap_excess_glccid, nvl(psl.gl_code_combination_id, nvl(poa.gl_code_combination_id, nvl(peta.gl_code_combination_id, pdls.gl_code_combination_id))))), nvl(pdl.suspense_auto_glccid, poa2.gl_code_combination_id)), NULL) glccid, DECODE(pdl.gl_project_flag, 'P', DECODE(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_project_id, nvl(psl.project_id, nvl(poa.project_id, nvl(peta.project_id, pdls.project_id)))),poa2.project_id), NULL) project_id, DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_task_id, nvl(psl.task_id, nvl(poa.task_id, nvl(peta.task_id, pdls.task_id)))),poa2.task_id), NULL) task_id, DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_award_id, nvl(psl.award_id, nvl(poa.award_id, nvl(peta.award_id, pdls.award_id)))),poa2.award_id), NULL) award_id, DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.auto_expenditure_type, nvl(pdl.cap_excess_exp_type, nvl(psl.expenditure_type, nvl(poa.expenditure_type, nvl(peta.expenditure_type, pdls.expenditure_type))))), nvl(pdl.suspense_auto_exp_type,poa2.expenditure_type)), NULL) expenditure_type, DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_exp_org_id, nvl(psl.expenditure_organization_id, nvl(poa.expenditure_organization_id, nvl(peta.expenditure_organization_id, pdls.expenditure_organization_id)))),poa2.expenditure_organization_id), NULL) exp_org_id, pdl.suspense_reason_code suspense_reason_code, ppsl.payroll_sub_line_id, PSP_PSPRCSLD_XMLP_PKG.cf_dl_credit_amount_dspformula(sum ( DECODE ( ppl.dr_cr_flag , 'C' , pdl.distribution_amount , 0 ) ), :CF_currency_format) CF_DL_Credit_Amount_dsp, PSP_PSPRCSLD_XMLP_PKG.cf_dl_debit_amount_dspformula(sum ( DECODE ( ppl.dr_cr_flag , 'D' , pdl.distribution_amount , 0 ) ), :CF_currency_format) CF_DL_Debit_Amount_dsp, PSP_PSPRCSLD_XMLP_PKG.cf_charging_instructionsformul(DECODE ( pdl.gl_project_flag , 'G' , DECODE ( pdl.suspense_org_Account_id , NULL , nvl ( pdl.auto_gl_code_combination_id , nvl ( pdl.cap_excess_glccid , nvl ( psl.gl_code_combination_id , nvl ( poa.gl_code_combination_id , nvl ( peta.gl_code_combination_id , pdls.gl_code_combination_id ) ) ) ) ) , nvl ( pdl.suspense_auto_glccid , poa2.gl_code_combination_id ) ) , NULL ), DECODE ( pdl.gl_project_flag , 'P' , DECODE ( pdl.suspense_org_account_id , NULL , nvl ( pdl.cap_excess_project_id , nvl ( psl.project_id , nvl ( poa.project_id , nvl ( peta.project_id , pdls.project_id ) ) ) ) , poa2.project_id ) , NULL ), DECODE ( pdl.gl_project_flag , 'P' , decode ( pdl.suspense_org_account_id , NULL , nvl ( pdl.cap_excess_task_id , nvl ( psl.task_id , nvl ( poa.task_id , nvl ( peta.task_id , pdls.task_id ) ) ) ) , poa2.task_id ) , NULL ), DECODE ( pdl.gl_project_flag , 'P' , decode ( pdl.suspense_org_account_id , NULL , nvl ( pdl.cap_excess_award_id , nvl ( psl.award_id , nvl ( poa.award_id , nvl ( peta.award_id , pdls.award_id ) ) ) ) , poa2.award_id ) , NULL ), DECODE ( pdl.gl_project_flag , 'P' , decode ( pdl.suspense_org_account_id , NULL , nvl ( pdl.cap_excess_exp_org_id , nvl ( psl.expenditure_organization_id , nvl ( poa.expenditure_organization_id , nvl ( peta.expenditure_organization_id , pdls.expenditure_organization_id ) ) ) ) , poa2.expenditure_organization_id ) , NULL ), DECODE ( pdl.gl_project_flag , 'P' , decode ( pdl.suspense_org_account_id , NULL , nvl ( pdl.auto_expenditure_type , nvl ( pdl.cap_excess_exp_type , nvl ( psl.expenditure_type , nvl ( poa.expenditure_type , nvl ( peta.expenditure_type , pdls.expenditure_type ) ) ) ) ) , nvl ( pdl.suspense_auto_exp_type , poa2.expenditure_type ) ) , NULL )) CF_Charging_Instructions FROM Psp_distribution_lines pdl, psp_payroll_sub_lines ppsl, psp_payroll_lines ppl, psp_schedule_lines psl, psp_organization_accounts poa, psp_element_type_accounts peta, psp_default_labor_Schedules pdls, psp_organization_accounts poa2 WHERE ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id AND ppsl.payroll_line_id = ppl.payroll_line_id AND pdl.schedule_line_id = psl.schedule_line_id(+) AND pdl.default_org_account_id = poa.organization_account_id(+) AND pdl.element_account_id = peta.element_account_id(+) AND pdl.org_schedule_id = pdls.org_schedule_id(+) AND pdl.suspense_org_account_id = poa2.organization_account_id(+) AND (pdl.reversal_entry_flag = 'N' OR pdl.reversal_entry_flag IS NULL) AND pdl.status_code = 'N' and ppsl.payroll_sub_line_id=:payroll_sub_line_id1 GROUP BY ppl.dr_cr_flag, DECODE(pdl.gl_project_flag, 'G', DECODE(pdl.suspense_org_Account_id, NULL, nvl(pdl.auto_gl_code_combination_id, nvl(pdl.cap_excess_glccid, nvl(psl.gl_code_combination_id, nvl(poa.gl_code_combination_id, nvl(peta.gl_code_combination_id, pdls.gl_code_combination_id))))), nvl(pdl.suspense_auto_glccid,poa2.gl_code_combination_id)), NULL), DECODE(pdl.gl_project_flag, 'P', DECODE(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_project_id, nvl(psl.project_id, nvl(poa.project_id, nvl(peta.project_id, pdls.project_id)))),poa2.project_id), NULL), DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_Excess_task_id, nvl(psl.task_id, nvl(poa.task_id, nvl(peta.task_id, pdls.task_id)))),poa2.task_id), NULL), DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_award_id, nvl(psl.award_id, nvl(poa.award_id, nvl(peta.award_id, pdls.award_id)))),poa2.award_id), NULL), DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.auto_expenditure_type, nvl(pdl.cap_Excess_exp_type, nvl(psl.expenditure_type, nvl(poa.expenditure_type, nvl(peta.expenditure_type, pdls.expenditure_type))))), nvl(pdl.suspense_auto_exp_type,poa2.expenditure_type)), NULL), DECODE(pdl.gl_project_flag, 'P', decode(pdl.suspense_org_account_id, NULL, nvl(pdl.cap_excess_exp_org_id, nvl(psl.expenditure_organization_id, nvl(poa.expenditure_organization_id, nvl(peta.expenditure_organization_id, pdls.expenditure_organization_id)))),poa2.expenditure_organization_id), NULL), pdl.suspense_reason_code, ppsl.payroll_sub_line_id ORDER BY min(pdl.distribution_date), max(pdl.distribution_date) PSP PSPRCSLD_XML PTB PSP Reconciliação entre as sublinhas e as linhas da classificação contábil Imported from BI Publisher Description: Reconciliação entre as sublinhas e as linhas da classificação contábil Application: Distribuição da Mão de Obra Source: PSP: Reconciliação entre as sublinhas e as linhas da classificação contábil (XML) Short Name: PSPRCSLD_XML DB package: PSP_PSPRCSLD_XMLP_PKG US PSP Reconciliation between sublines and distribution lines Imported from BI Publisher Description: Reconciliation between sublines and distribution lines Application: Labor Distribution Source: PSP: Reconciliation between sublines and distribution lines (XML) Short Name: PSPRCSLD_XML DB package: PSP_PSPRCSLD_XMLP_PKG BI Publisher :cf_currency_format :p_batch_name :p_conc_request_id :p_payroll_id :p_set_of_books_id :p_source_code :p_source_type :p_start_date :p_time_period_id :payroll_sub_line_id1 1 -20 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y PTB P_SET_OF_BOOKS_ID Id do Razão US P_SET_OF_BOOKS_ID Ledger Id 2 10 :p_source_type LOV Oracle PSP_RECON_SOURCE_TYPE Y select lookup_code id, meaning value, null description from psp_lookups where lookup_type='PSP_SOURCE_TYPE' and lookup_code in ('O','N') and lookup_code in (select source_type from psp_payroll_controls where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID')) order by meaning Y PTB Tipo de Origem Tipo de Origem US Source Type Source Type 3 20 :p_source_code LOV Oracle PSP_RECON_SOURCE_CODE Y select source_code id, source_code value, null description from psp_payroll_sources where source_type=:$flex$.psp_recon_source_type and source_code in (select payroll_source_code from psp_payroll_controls where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID')) order by source_code Y PTB Código da Origem Código da Origem US Source Code Source Code 4 30 :p_payroll_id LOV Oracle PSP_SRS_IMP_PAYROLL_NAME Y select payroll_id id, payroll_name value, null description from pay_payrolls_f where sysdate between effective_start_date and effective_end_date and business_group_id=fnd_global.per_business_group_id and gl_set_of_books_id= fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description Y PTB Nome da Folha de Pagamento Nome da Folha de Pagamento US Payroll Name Payroll Name 5 40 :p_time_period_id LOV Oracle PSP_RECON_TIME_PERIOD Y select time_period_id id, period_name value, null description from per_time_periods where time_period_id in (select time_period_id from psp_payroll_controls where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') and payroll_id=:$flex$.psp_srs_imp_payroll_name and source_type=:$flex$.psp_recon_source_type and payroll_source_code=:$flex$.psp_recon_source_code) order by time_period_id Y PTB Período Período US Time Period Time Period 6 50 :p_batch_name LOV Oracle PSP_RECON_BATCH_NAME Y select batch_name id, batch_name value, null description from psp_batch_names_v where batch_name in (select batch_name from psp_payroll_controls where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and source_type=:$flex$.psp_recon_source_type and payroll_source_code=:$flex$.psp_recon_source_code) order by batch_name PTB Nome do Lote Nome do Lote US Batch Name Batch Name