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_CN_ARCH_PAYMENT_METHODS_V1

Source

View Text - Preformatted


SELECT pai.action_context_id assignment_action_id , pai.action_information1 org_paymeth_id , pop.org_payment_method_id org_payment_method_id , pop.org_payment_method_name org_payment_method_name , ppto.category org_payment_category , pea.segment1 org_bank_name , pea.segment2 org_bank_branch , pea.segment3 org_bank_account_number , pai.action_information2 personal_payment_method_id , pai.action_information18 personal_payment_method_name , pptp.category personal_payment_category , pai.action_information5 personal_bank_name , pai.action_information6 personal_bank_branch , pai.action_information7 personal_bank_account_number , pai.action_information13 currency_code , pai.action_information16 payment_amount FROM pay_action_information pai , pay_personal_payment_methods_f ppp , pay_org_payment_methods_f popp , pay_payment_types pptp , pay_org_payment_methods_f pop , pay_payment_types ppto , pay_external_accounts pea WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION' AND pai.action_context_type = 'AAP' AND pai.action_information2 = ppp.personal_payment_method_id AND pai.effective_date BETWEEN ppp.effective_start_date AND ppp.effective_end_date AND ppp.org_payment_method_id = popp.org_payment_method_id AND pai.effective_date BETWEEN popp.effective_start_date AND popp.effective_end_date AND popp.payment_type_id = pptp.payment_type_id AND pai.action_information1 = pop.org_payment_method_id AND pai.effective_date BETWEEN pop.effective_start_date AND pop.effective_end_date AND pop.payment_type_id = ppto.payment_type_id AND pop.external_account_id = pea.external_account_id

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, PAI.ACTION_INFORMATION1 ORG_PAYMETH_ID
, POP.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, POP.ORG_PAYMENT_METHOD_NAME ORG_PAYMENT_METHOD_NAME
, PPTO.CATEGORY ORG_PAYMENT_CATEGORY
, PEA.SEGMENT1 ORG_BANK_NAME
, PEA.SEGMENT2 ORG_BANK_BRANCH
, PEA.SEGMENT3 ORG_BANK_ACCOUNT_NUMBER
, PAI.ACTION_INFORMATION2 PERSONAL_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION18 PERSONAL_PAYMENT_METHOD_NAME
, PPTP.CATEGORY PERSONAL_PAYMENT_CATEGORY
, PAI.ACTION_INFORMATION5 PERSONAL_BANK_NAME
, PAI.ACTION_INFORMATION6 PERSONAL_BANK_BRANCH
, PAI.ACTION_INFORMATION7 PERSONAL_BANK_ACCOUNT_NUMBER
, PAI.ACTION_INFORMATION13 CURRENCY_CODE
, PAI.ACTION_INFORMATION16 PAYMENT_AMOUNT
FROM PAY_ACTION_INFORMATION PAI
, PAY_PERSONAL_PAYMENT_METHODS_F PPP
, PAY_ORG_PAYMENT_METHODS_F POPP
, PAY_PAYMENT_TYPES PPTP
, PAY_ORG_PAYMENT_METHODS_F POP
, PAY_PAYMENT_TYPES PPTO
, PAY_EXTERNAL_ACCOUNTS PEA
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE NET PAY DISTRIBUTION'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION2 = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PAI.EFFECTIVE_DATE BETWEEN PPP.EFFECTIVE_START_DATE
AND PPP.EFFECTIVE_END_DATE
AND PPP.ORG_PAYMENT_METHOD_ID = POPP.ORG_PAYMENT_METHOD_ID
AND PAI.EFFECTIVE_DATE BETWEEN POPP.EFFECTIVE_START_DATE
AND POPP.EFFECTIVE_END_DATE
AND POPP.PAYMENT_TYPE_ID = PPTP.PAYMENT_TYPE_ID
AND PAI.ACTION_INFORMATION1 = POP.ORG_PAYMENT_METHOD_ID
AND PAI.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE
AND POP.PAYMENT_TYPE_ID = PPTO.PAYMENT_TYPE_ID
AND POP.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID