VIEW: APPS.PAY_JP_MAGTAPE_PACTS_V

Source

View Text - Preformatted

SELECT ppa.business_group_id + 0, ppa.payroll_action_id, ppa.action_sequence, ppa.request_id, ppa.overriding_dd_date, ppa.start_date, ppa.effective_date, ppa.payroll_id, pp.payroll_name, ppa.consolidation_set_id, pcs.consolidation_set_name, ppa.org_payment_method_id, opmtl.org_payment_method_name, opm.currency_code, opm.pmeth_information_category, opm.pmeth_information_category, opm.pmeth_information1, opm.pmeth_information2, opm.pmeth_information3, opm.pmeth_information4, opm.pmeth_information5, opm.pmeth_information6, opm.pmeth_information7, opm.pmeth_information8, opm.pmeth_information9, opm.pmeth_information10, opm.pmeth_information11, opm.pmeth_information12, opm.pmeth_information13, opm.pmeth_information14, opm.pmeth_information15, opm.pmeth_information16, opm.pmeth_information17, opm.pmeth_information18, opm.pmeth_information19, opm.pmeth_information20, opm.external_account_id, pea.segment1, pea.segment2, pea.segment3, pea.segment4, pea.segment5, pea.segment6, pea.segment7, pea.segment8, pea.segment9, pea.segment10, pea.segment11, pea.segment12, pea.segment13, pea.segment14, pea.segment15, pea.segment16, pea.segment17, pea.segment18, pea.segment19, pea.segment20, pea.segment21, pea.segment22, pea.segment23, pea.segment24, pea.segment25, pea.segment26, pea.segment27, pea.segment28, pea.segment29, pea.segment30 from pay_external_accounts pea, pay_payrolls_f pp, pay_org_payment_methods_f_tl opmtl, pay_org_payment_methods_f opm, pay_consolidation_sets pcs, pay_payroll_actions ppa where ppa.action_type = 'M' and ppa.action_status = 'C' and pcs.consolidation_set_id = ppa.consolidation_set_id and opm.org_payment_method_id = ppa.org_payment_method_id and ppa.effective_date between opm.effective_start_date and opm.effective_end_date and opmtl.org_payment_method_id = opm.org_payment_method_id and opmtl.language = userenv('LANG') and pp.payroll_id(+) = ppa.payroll_id and ppa.effective_date between pp.effective_start_date(+) and pp.effective_end_date(+) and pea.external_account_id = opm.external_account_id

View Text - HTML Formatted

SELECT PPA.BUSINESS_GROUP_ID + 0
, PPA.PAYROLL_ACTION_ID
, PPA.ACTION_SEQUENCE
, PPA.REQUEST_ID
, PPA.OVERRIDING_DD_DATE
, PPA.START_DATE
, PPA.EFFECTIVE_DATE
, PPA.PAYROLL_ID
, PP.PAYROLL_NAME
, PPA.CONSOLIDATION_SET_ID
, PCS.CONSOLIDATION_SET_NAME
, PPA.ORG_PAYMENT_METHOD_ID
, OPMTL.ORG_PAYMENT_METHOD_NAME
, OPM.CURRENCY_CODE
, OPM.PMETH_INFORMATION_CATEGORY
, OPM.PMETH_INFORMATION_CATEGORY
, OPM.PMETH_INFORMATION1
, OPM.PMETH_INFORMATION2
, OPM.PMETH_INFORMATION3
, OPM.PMETH_INFORMATION4
, OPM.PMETH_INFORMATION5
, OPM.PMETH_INFORMATION6
, OPM.PMETH_INFORMATION7
, OPM.PMETH_INFORMATION8
, OPM.PMETH_INFORMATION9
, OPM.PMETH_INFORMATION10
, OPM.PMETH_INFORMATION11
, OPM.PMETH_INFORMATION12
, OPM.PMETH_INFORMATION13
, OPM.PMETH_INFORMATION14
, OPM.PMETH_INFORMATION15
, OPM.PMETH_INFORMATION16
, OPM.PMETH_INFORMATION17
, OPM.PMETH_INFORMATION18
, OPM.PMETH_INFORMATION19
, OPM.PMETH_INFORMATION20
, OPM.EXTERNAL_ACCOUNT_ID
, PEA.SEGMENT1
, PEA.SEGMENT2
, PEA.SEGMENT3
, PEA.SEGMENT4
, PEA.SEGMENT5
, PEA.SEGMENT6
, PEA.SEGMENT7
, PEA.SEGMENT8
, PEA.SEGMENT9
, PEA.SEGMENT10
, PEA.SEGMENT11
, PEA.SEGMENT12
, PEA.SEGMENT13
, PEA.SEGMENT14
, PEA.SEGMENT15
, PEA.SEGMENT16
, PEA.SEGMENT17
, PEA.SEGMENT18
, PEA.SEGMENT19
, PEA.SEGMENT20
, PEA.SEGMENT21
, PEA.SEGMENT22
, PEA.SEGMENT23
, PEA.SEGMENT24
, PEA.SEGMENT25
, PEA.SEGMENT26
, PEA.SEGMENT27
, PEA.SEGMENT28
, PEA.SEGMENT29
, PEA.SEGMENT30
FROM PAY_EXTERNAL_ACCOUNTS PEA
, PAY_PAYROLLS_F PP
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_CONSOLIDATION_SETS PCS
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.ACTION_TYPE = 'M'
AND PPA.ACTION_STATUS = 'C'
AND PCS.CONSOLIDATION_SET_ID = PPA.CONSOLIDATION_SET_ID
AND OPM.ORG_PAYMENT_METHOD_ID = PPA.ORG_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND OPMTL.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND PP.PAYROLL_ID(+) = PPA.PAYROLL_ID
AND PPA.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE(+)
AND PP.EFFECTIVE_END_DATE(+)
AND PEA.EXTERNAL_ACCOUNT_ID = OPM.EXTERNAL_ACCOUNT_ID