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_UTILITY_PVT dependencies on IBY_PAYMENTS_ALL

Line 849: from iby_payments_all pmt, iby_pay_instructions_all instr

845: iby.payment_service_request_status = 'PAYMENTS_CREATED'
846: AND EXISTS
847: (
848: select 'NEED_ACTION_BY_ME'
849: from iby_payments_all pmt, iby_pay_instructions_all instr
850: where iby.payment_service_request_id = pmt.payment_service_request_id
851: and instr.payment_instruction_id = pmt.payment_instruction_id
852: and instr.payment_instruction_status IN ('CREATION_ERROR',
853: 'FORMATTED_READY_TO_TRANSMIT',

Line 904: FROM iby_payments_all pmt

900: (
901: iby.payment_service_request_status IN ('PAYMENTS_CREATED')
902: AND EXISTS
903: (SELECT 'PROCESSING'
904: FROM iby_payments_all pmt
905: WHERE
906: pmt.payment_service_request_id = iby.payment_service_request_id
907: AND pmt.payment_status NOT IN('REMOVED', 'VOID', 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED',
908: 'REMOVED_DOCUMENT_SPOILED', 'REMOVED_INSTRUCTION_TERMINATED', 'REMOVED_REQUEST_TERMINATED', 'ISSUED', 'TRANSMITTED', 'REJECTED')

Line 1050: FROM iby_payments_all

1046: select count (*) total_pmt_count,
1047: count(case when PAYMENTS_COMPLETE_FLAG = 'Y' then 1 else null
1048: end) pmt_complete_count
1049: into l_total_pmt_count, l_pmt_complete_count /*Bug 7248943*/
1050: FROM iby_payments_all
1051: WHERE payment_service_request_id = p_psr_id
1052: AND payment_status NOT IN ('REMOVED', 'VOID_BY_SETUP',
1053: 'VOID_BY_OVERFLOW', 'REMOVED_PAYMENT_STOPPED',
1054: 'REMOVED_DOCUMENT_SPOILED',

Line 1163: from iby_payments_all

1159: count(case when PAYMENT_STATUS IN ('REMOVED_DOCUMENT_SPOILED',
1160: 'REMOVED_DOCUMENT_SKIPPED') then 1
1161: else null end) pmt_spoil_skip
1162: into l_total_pmt_count, l_instr_count, l_pmt_terminate_count, l_pmt_spoil_skip
1163: from iby_payments_all
1164: WHERE payment_service_request_id = p_psr_id ;
1165: /*Bug 7248943*/
1166:
1167: IF (l_instr_count = 0 AND p_psr_status = 'PAYMENTS_CREATED') THEN

Line 1243: select 'N' into l_access from dual where exists ( select 'Inaccessible org' from iby_payments_all where

1239: THEN
1240: l_access := g_instr_access_table(p_pay_instruction_id).access_flag;
1241: ELSE
1242: begin
1243: select 'N' into l_access from dual where exists ( select 'Inaccessible org' from iby_payments_all where
1244: payment_instruction_id = p_pay_instruction_id and MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');
1245:
1246: Exception
1247: when NO_DATA_FOUND