eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_BATCH_BAL_ADJ_CE_V

Source

View Text - Preformatted


SELECT pbbh.batch_id, pbbh.batch_name, ettl.element_name,pbbh.business_group_id, pabg.batch_group_id, pabl.batch_line_id, pabl.batch_line_status, et.element_type_id,null,pabg.effective_date,ppf.full_name, paf.assignment_number, pp.PAYROLL_NAME, pcs.CONSOLIDATION_SET_NAME, decode(pabl.tax_unit_id,null,null, (SELECT name FROM hr_all_organization_units_tl WHERE LANGUAGE = userenv('LANG') AND organization_id = pabl.tax_unit_id)) GRE, hr_general.decode_lookup('YES_NO',pabg.PREPAY_FLAG) prepay_flag, hr_general.decode_lookup('YES_NO',pabl.BALANCE_ADJ_COST_FLAG) costing_flag, PABL.COST_ALLOCATION_KEYFLEX_ID,CAK.CONCATENATED_SEGMENTS, cak.segment1,cak.segment2,cak.segment3,cak.segment4,cak.segment5, cak.segment6,cak.segment7,cak.segment8,cak.segment9,cak.segment10, cak.segment11,cak.segment12,cak.segment13,cak.segment14,cak.segment15, cak.segment16,cak.segment17,cak.segment18,cak.segment19,cak.segment20, cak.segment21,cak.segment22,cak.segment23,cak.segment24,cak.segment25, cak.segment26,cak.segment27,cak.segment28,cak.segment29,cak.segment30, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE1,1,SYSDATE,PABL.BATCH_ID, 'Q') VAL1, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE2,2,SYSDATE,PABL.BATCH_ID, 'Q') VAL2, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE3,3,SYSDATE,PABL.BATCH_ID, 'Q') VAL3, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE4,4,SYSDATE,PABL.BATCH_ID, 'Q') VAL4, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE5,5,SYSDATE,PABL.BATCH_ID, 'Q') VAL5, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE6,6,SYSDATE,PABL.BATCH_ID, 'Q') VAL6, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE7,7,SYSDATE,PABL.BATCH_ID, 'Q') VAL7, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE8,8,SYSDATE,PABL.BATCH_ID, 'Q') VAL8, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE9,9,SYSDATE,PABL.BATCH_ID, 'Q') VAL9, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE10,10,SYSDATE,PABL.BATCH_ID, 'Q') VAL10, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE11,11,SYSDATE,PABL.BATCH_ID, 'Q') VAL11, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE12,12,SYSDATE,PABL.BATCH_ID, 'Q') VAL12, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE13,13,SYSDATE,PABL.BATCH_ID, 'Q') VAL13, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE14,14,SYSDATE,PABL.BATCH_ID, 'Q') VAL14, pay_batch_balanceadj_wrapper.CONVERT_INTERNAL_TO_DISPLAY(pabl.ELEMENT_TYPE_ID, pabl.ENTRY_VALUE15,15,SYSDATE,PABL.BATCH_ID, 'Q') VAL15, decode(pabl.batch_line_status,'E', (select line_text from pay_message_lines where source_type='L' and source_id = pabl.batch_line_id), null) error_message from pay_adjust_batch_lines pabl, pay_adjust_batch_groups pabg, pay_balance_batch_headers pbbh,pay_element_types_f_tl ettl, pay_element_types_f et,per_all_people_f ppf, per_all_assignments_f paf,pay_all_payrolls_f pp,pay_consolidation_sets pcs, pay_cost_allocation_keyflex cak where pabg.batch_id = pbbh.batch_id and pabl.batch_id = pbbh.batch_id and pabg.batch_group_status not in ('L','T') and pabl.batch_group_id = pabg.batch_group_id and pabl.batch_line_status != 'T' and et.element_type_id = pabl.element_type_id and pabg.effective_date between et.effective_start_date and et.effective_end_date and ettl.element_type_id = et.element_type_id and ettl.language = USERENV('LANG') and paf.assignment_id = pabl.assignment_id and pabg.effective_date between paf.effective_start_date and paf.effective_end_date and paf.person_id = ppf.person_id and pabg.effective_date between ppf.effective_start_date and ppf.effective_end_date and pabg.payroll_id = pp.payroll_id and pabg.effective_date between pp.effective_start_date and pp.effective_end_date and pabg.CONSOLIDATION_SET_ID = pcs.CONSOLIDATION_SET_ID and cak.COST_ALLOCATION_KEYFLEX_ID(+) = pabl.COST_ALLOCATION_KEYFLEX_ID

View Text - HTML Formatted

SELECT PBBH.BATCH_ID
, PBBH.BATCH_NAME
, ETTL.ELEMENT_NAME
, PBBH.BUSINESS_GROUP_ID
, PABG.BATCH_GROUP_ID
, PABL.BATCH_LINE_ID
, PABL.BATCH_LINE_STATUS
, ET.ELEMENT_TYPE_ID
, NULL
, PABG.EFFECTIVE_DATE
, PPF.FULL_NAME
, PAF.ASSIGNMENT_NUMBER
, PP.PAYROLL_NAME
, PCS.CONSOLIDATION_SET_NAME
, DECODE(PABL.TAX_UNIT_ID
, NULL
, NULL
, (SELECT NAME
FROM HR_ALL_ORGANIZATION_UNITS_TL
WHERE LANGUAGE = USERENV('LANG')
AND ORGANIZATION_ID = PABL.TAX_UNIT_ID)) GRE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PABG.PREPAY_FLAG) PREPAY_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PABL.BALANCE_ADJ_COST_FLAG) COSTING_FLAG
, PABL.COST_ALLOCATION_KEYFLEX_ID
, CAK.CONCATENATED_SEGMENTS
, CAK.SEGMENT1
, CAK.SEGMENT2
, CAK.SEGMENT3
, CAK.SEGMENT4
, CAK.SEGMENT5
, CAK.SEGMENT6
, CAK.SEGMENT7
, CAK.SEGMENT8
, CAK.SEGMENT9
, CAK.SEGMENT10
, CAK.SEGMENT11
, CAK.SEGMENT12
, CAK.SEGMENT13
, CAK.SEGMENT14
, CAK.SEGMENT15
, CAK.SEGMENT16
, CAK.SEGMENT17
, CAK.SEGMENT18
, CAK.SEGMENT19
, CAK.SEGMENT20
, CAK.SEGMENT21
, CAK.SEGMENT22
, CAK.SEGMENT23
, CAK.SEGMENT24
, CAK.SEGMENT25
, CAK.SEGMENT26
, CAK.SEGMENT27
, CAK.SEGMENT28
, CAK.SEGMENT29
, CAK.SEGMENT30
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE1
, 1
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL1
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE2
, 2
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL2
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE3
, 3
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL3
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE4
, 4
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL4
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE5
, 5
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL5
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE6
, 6
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL6
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE7
, 7
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL7
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE8
, 8
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL8
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE9
, 9
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL9
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE10
, 10
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL10
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE11
, 11
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL11
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE12
, 12
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL12
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE13
, 13
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL13
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE14
, 14
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL14
, PAY_BATCH_BALANCEADJ_WRAPPER.CONVERT_INTERNAL_TO_DISPLAY(PABL.ELEMENT_TYPE_ID
, PABL.ENTRY_VALUE15
, 15
, SYSDATE
, PABL.BATCH_ID
, 'Q') VAL15
, DECODE(PABL.BATCH_LINE_STATUS
, 'E'
, (SELECT LINE_TEXT
FROM PAY_MESSAGE_LINES
WHERE SOURCE_TYPE='L'
AND SOURCE_ID = PABL.BATCH_LINE_ID)
, NULL) ERROR_MESSAGE
FROM PAY_ADJUST_BATCH_LINES PABL
, PAY_ADJUST_BATCH_GROUPS PABG
, PAY_BALANCE_BATCH_HEADERS PBBH
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAF
, PAY_ALL_PAYROLLS_F PP
, PAY_CONSOLIDATION_SETS PCS
, PAY_COST_ALLOCATION_KEYFLEX CAK
WHERE PABG.BATCH_ID = PBBH.BATCH_ID
AND PABL.BATCH_ID = PBBH.BATCH_ID
AND PABG.BATCH_GROUP_STATUS NOT IN ('L'
, 'T')
AND PABL.BATCH_GROUP_ID = PABG.BATCH_GROUP_ID
AND PABL.BATCH_LINE_STATUS != 'T'
AND ET.ELEMENT_TYPE_ID = PABL.ELEMENT_TYPE_ID
AND PABG.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND ETTL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND PAF.ASSIGNMENT_ID = PABL.ASSIGNMENT_ID
AND PABG.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAF.PERSON_ID = PPF.PERSON_ID
AND PABG.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PABG.PAYROLL_ID = PP.PAYROLL_ID
AND PABG.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND PABG.CONSOLIDATION_SET_ID = PCS.CONSOLIDATION_SET_ID
AND CAK.COST_ALLOCATION_KEYFLEX_ID(+) = PABL.COST_ALLOCATION_KEYFLEX_ID