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.

APPS.IBY_PAYMENT_MANAGER_PKG dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 177: FROM iby_pay_instructions_all inst

173: 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED')
174: AND pmt.payments_complete_flag <> 'Y'
175: AND NOT EXISTS
176: (SELECT 'NEED_ACTION'
177: FROM iby_pay_instructions_all inst
178: WHERE pmt.payment_instruction_id = inst.payment_instruction_id
179: AND (inst.payment_instruction_status IN('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED', 'FORMATTED_READY_FOR_PRINTING', 'SUBMITTED_FOR_PRINTING',
180: 'CREATED_READY_FOR_PRINTING', 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED', 'FORMATTED_ELECTRONIC')
181: )

Line 240: iby_pay_instructions_all instr

236: FROM
237: (SELECT DISTINCT pmt.payment_instruction_id INSTR_ID,
238: pmt.org_id ORG_ID
239: FROM iby_payments_all pmt,
240: iby_pay_instructions_all instr
241: WHERE p_payment_service_request_id = pmt.payment_service_request_id
242: AND instr.payment_instruction_id = pmt.payment_instruction_id
243: AND (instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED', 'FORMATTED_READY_FOR_PRINTING',
244: 'SUBMITTED_FOR_PRINTING', 'CREATED_READY_FOR_PRINTING', 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED'))