VIEW: APPS.PAY_CN_ARCH_PAYMENT_METHODS_V2

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 , pai.action_information18 org_payment_method_name , ppt.category org_payment_category , pai.action_information5 org_bank_name , pai.action_information6 org_bank_branch , pai.action_information7 org_bank_account_number , pai.action_information1 personal_payment_method_id , pai.action_information18 personal_payment_method_name , ppt.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_org_payment_methods_f pop , pay_payment_types ppt WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION' AND pai.action_context_type = 'AAP' AND pai.action_information2 IS NULL AND pai.action_information1 = pop.org_payment_method_id AND pop.payment_type_id = ppt.payment_type_id AND pai.effective_date BETWEEN pop.effective_start_date AND pop.effective_end_date

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
, PAI.ACTION_INFORMATION18 ORG_PAYMENT_METHOD_NAME
, PPT.CATEGORY ORG_PAYMENT_CATEGORY
, PAI.ACTION_INFORMATION5 ORG_BANK_NAME
, PAI.ACTION_INFORMATION6 ORG_BANK_BRANCH
, PAI.ACTION_INFORMATION7 ORG_BANK_ACCOUNT_NUMBER
, PAI.ACTION_INFORMATION1 PERSONAL_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION18 PERSONAL_PAYMENT_METHOD_NAME
, PPT.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_ORG_PAYMENT_METHODS_F POP
, PAY_PAYMENT_TYPES PPT
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE NET PAY DISTRIBUTION'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION2 IS NULL
AND PAI.ACTION_INFORMATION1 = POP.ORG_PAYMENT_METHOD_ID
AND POP.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND PAI.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE