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_US_PRE_PAYMENTS_V

Source

View Text - Preformatted


SELECT ppp.pre_payment_id, ppp.personal_payment_method_id, ppp.assignment_action_id, ppp.org_payment_method_id, ppp.value, ppp.base_currency_value, ppp.source_action_id, ppp.prepayment_action_id, paa_check.serial_number serial_number, ppa_check.action_type action_type, paa_check.assignment_action_id check_assignment_action_id, paa_pre.payroll_Action_id payroll_action_id from pay_org_payment_methods_f popm, pay_pre_payments ppp, pay_assignment_actions paa_pre, pay_assignment_actions paa_check, pay_payroll_Actions ppa_check, pay_action_interlocks pai WHERE pai.locked_action_id = paa_pre.assignment_action_id and paa_check.assignment_action_id = pai.locking_action_id and ppa_check.payroll_action_id = paa_check.payroll_action_id and ppa_check.action_type in ('H', 'E','M') and paa_check.action_status = 'C' and paa_check.pre_payment_id = ppp.pre_payment_id and popm.org_payment_method_id = ppp.org_payment_method_id and ppa_check.effective_date between popm.effective_start_date and popm.effective_end_date UNION select ppp.pre_payment_id, ppp.personal_payment_method_id, ppp.assignment_action_id, ppp.org_payment_method_id, ppp.value, ppp.base_currency_value, ppp.source_action_id, ppp.prepayment_action_id, NULL serial_number, NULL action_type, 0 check_assignment_action_id, 0 payroll_action_id from pay_pre_payments ppp where not exists (select 1 from pay_assignment_actions paa where paa.pre_payment_id = ppp.pre_payment_id)

View Text - HTML Formatted

SELECT PPP.PRE_PAYMENT_ID
, PPP.PERSONAL_PAYMENT_METHOD_ID
, PPP.ASSIGNMENT_ACTION_ID
, PPP.ORG_PAYMENT_METHOD_ID
, PPP.VALUE
, PPP.BASE_CURRENCY_VALUE
, PPP.SOURCE_ACTION_ID
, PPP.PREPAYMENT_ACTION_ID
, PAA_CHECK.SERIAL_NUMBER SERIAL_NUMBER
, PPA_CHECK.ACTION_TYPE ACTION_TYPE
, PAA_CHECK.ASSIGNMENT_ACTION_ID CHECK_ASSIGNMENT_ACTION_ID
, PAA_PRE.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
FROM PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAA_PRE
, PAY_ASSIGNMENT_ACTIONS PAA_CHECK
, PAY_PAYROLL_ACTIONS PPA_CHECK
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKED_ACTION_ID = PAA_PRE.ASSIGNMENT_ACTION_ID
AND PAA_CHECK.ASSIGNMENT_ACTION_ID = PAI.LOCKING_ACTION_ID
AND PPA_CHECK.PAYROLL_ACTION_ID = PAA_CHECK.PAYROLL_ACTION_ID
AND PPA_CHECK.ACTION_TYPE IN ('H'
, 'E'
, 'M')
AND PAA_CHECK.ACTION_STATUS = 'C'
AND PAA_CHECK.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID
AND POPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPA_CHECK.EFFECTIVE_DATE BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE UNION SELECT PPP.PRE_PAYMENT_ID
, PPP.PERSONAL_PAYMENT_METHOD_ID
, PPP.ASSIGNMENT_ACTION_ID
, PPP.ORG_PAYMENT_METHOD_ID
, PPP.VALUE
, PPP.BASE_CURRENCY_VALUE
, PPP.SOURCE_ACTION_ID
, PPP.PREPAYMENT_ACTION_ID
, NULL SERIAL_NUMBER
, NULL ACTION_TYPE
, 0 CHECK_ASSIGNMENT_ACTION_ID
, 0 PAYROLL_ACTION_ID
FROM PAY_PRE_PAYMENTS PPP
WHERE NOT EXISTS (SELECT 1
FROM PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAA.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID)