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_ZA_EXTERNAL_ACCOUNTS_V

Source

View Text - Preformatted


SELECT paa.rowid row_id, paa.assignment_action_id assignment_action_id, substr(popmf.org_payment_method_name,1,30) payment_method, cdv.bank_name bank, pea.segment1 branch_code, pea.segment3 account_no, ppp.value payment_amount, ppa.date_earned payment_date from pay_pre_payments ppp, pay_personal_payment_methods_f pppmf, pay_org_payment_methods_f popmf, pay_external_accounts pea, pay_za_branch_cdv_details cdv, pay_assignment_actions paa, pay_payroll_actions ppa WHERE paa.payroll_action_id = ppa.payroll_action_id and ppa.action_type in ('P','U') and ppp.assignment_action_id = paa.assignment_action_id and pppmf.personal_payment_method_id (+) = ppp.personal_payment_method_id and ppa.effective_date between nvl(pppmf.effective_start_date, to_date('01-01-0001','DD-MM-YYYY')) and nvl(pppmf.effective_end_date, to_date('31-12-4712','DD-MM-YYYY')) and ppa.effective_date between popmf.effective_start_date and popmf.effective_end_date and popmf.org_payment_method_id = ppp.org_payment_method_id and pea.external_account_id (+) = pppmf.external_account_id and cdv.branch_code (+) = pea.segment1

View Text - HTML Formatted

SELECT PAA.ROWID ROW_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(POPMF.ORG_PAYMENT_METHOD_NAME
, 1
, 30) PAYMENT_METHOD
, CDV.BANK_NAME BANK
, PEA.SEGMENT1 BRANCH_CODE
, PEA.SEGMENT3 ACCOUNT_NO
, PPP.VALUE PAYMENT_AMOUNT
, PPA.DATE_EARNED PAYMENT_DATE
FROM PAY_PRE_PAYMENTS PPP
, PAY_PERSONAL_PAYMENT_METHODS_F PPPMF
, PAY_ORG_PAYMENT_METHODS_F POPMF
, PAY_EXTERNAL_ACCOUNTS PEA
, PAY_ZA_BRANCH_CDV_DETAILS CDV
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPP.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPPMF.PERSONAL_PAYMENT_METHOD_ID (+) = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PPPMF.EFFECTIVE_START_DATE
, TO_DATE('01-01-0001'
, 'DD-MM-YYYY'))
AND NVL(PPPMF.EFFECTIVE_END_DATE
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND PPA.EFFECTIVE_DATE BETWEEN POPMF.EFFECTIVE_START_DATE
AND POPMF.EFFECTIVE_END_DATE
AND POPMF.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PEA.EXTERNAL_ACCOUNT_ID (+) = PPPMF.EXTERNAL_ACCOUNT_ID
AND CDV.BRANCH_CODE (+) = PEA.SEGMENT1