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_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_TRXN_SUMMARIES_ALL

Line 157: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||

153: l_extract_query VARCHAR2(4000) :=
154: 'select XMLElement("FundsCapturePayerNotification", ' ||
155: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||
156: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||
157: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
158: ' where txn.trxnmid = xml_order.trxnmid ' ||
159: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
160:
161: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;

Line 161: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;

157: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
158: ' where txn.trxnmid = xml_order.trxnmid ' ||
159: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
160:
161: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;
162: -- l_mbatchid VARCHAR2(100);
163: -- l_toDate VARCHAR2(100);
164: -- l_delivery_method VARCHAR2(30);
165: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;

Line 165: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;

161: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;
162: -- l_mbatchid VARCHAR2(100);
163: -- l_toDate VARCHAR2(100);
164: -- l_delivery_method VARCHAR2(30);
165: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;
166: -- l_toPSON iby_trxn_summaries_all.tangibleid%TYPE;
167:
168: BEGIN
169:

Line 166: -- l_toPSON iby_trxn_summaries_all.tangibleid%TYPE;

162: -- l_mbatchid VARCHAR2(100);
163: -- l_toDate VARCHAR2(100);
164: -- l_delivery_method VARCHAR2(30);
165: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;
166: -- l_toPSON iby_trxn_summaries_all.tangibleid%TYPE;
167:
168: BEGIN
169:
170: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

Line 461: iby_trxn_summaries_all txn,

457: )--,
458: --txn.mbatchid,
459: --txn.payeeinstrid
460: FROM
461: iby_trxn_summaries_all txn,
462: iby_payee payee,
463: iby_bepkeys keys,
464: iby_xml_fndcpt_bankaccount_v xml_bank,
465: iby_xml_bep_acct_options_v opts,

Line 540: iby_trxn_summaries_all txn,

536: )--,
537: --txn.mbatchid,
538: --txn.payeeinstrid
539: FROM
540: iby_trxn_summaries_all txn,
541: iby_payee payee,
542: iby_bepkeys keys,
543: iby_xml_fndcpt_bankaccount_v xml_bank,
544: iby_xml_bep_acct_options_v opts,

Line 622: FROM iby_trxn_summaries_all txn, iby_batches_all bat

618: l_ps_territory VARCHAR2(60);
619:
620: CURSOR l_instrument_type_csr (p_trxnmid IN NUMBER) IS
621: SELECT bat.instrument_type
622: FROM iby_trxn_summaries_all txn, iby_batches_all bat
623: WHERE txn.trxnmid = p_trxnmid
624: AND txn.mbatchid = bat.mbatchid;
625:
626: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS

Line 629: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

625:
626: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS
627: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
628: sys_pf.payer_notification_format
629: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
630: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf
631: WHERE txn.trxnmid = p_trxnmid
632: AND txn.mbatchid = bat.mbatchid
633: AND bat.process_profile_code = user_pf.user_eft_profile_code

Line 639: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

635:
636: CURSOR l_cc_sra_setup_csr (p_trxnmid IN NUMBER) IS
637: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
638: sys_pf.payer_notification_format
639: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
640: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf
641: WHERE txn.trxnmid = p_trxnmid
642: AND txn.mbatchid = bat.mbatchid
643: AND bat.process_profile_code = user_pf.user_cc_profile_code

Line 649: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

645:
646: CURSOR l_dc_sra_setup_csr (p_trxnmid IN NUMBER) IS
647: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
648: sys_pf.payer_notification_format
649: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
650: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf
651: WHERE txn.trxnmid = p_trxnmid
652: AND txn.mbatchid = bat.mbatchid
653: AND bat.process_profile_code = user_pf.user_dc_profile_code

Line 659: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,

655:
656: CURSOR l_lang_territory_csr (p_trxnmid IN NUMBER) IS
657: SELECT loc.language, loc.country
658: FROM hz_party_sites ps, hz_locations loc,
659: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,
660: hz_cust_acct_sites_all hz_cs
661: where txn.trxnmid = p_trxnmid
662: and hz_csu.cust_acct_site_id = hz_cs.cust_acct_site_id
663: and hz_cs.party_site_id = ps.party_site_id

Line 748: iby_trxn_summaries_all txn

744: SELECT payer.debit_advice_delivery_method,
745: payer.debit_advice_email,
746: payer.debit_advice_fax
747: FROM iby_external_payers_all payer,
748: iby_trxn_summaries_all txn
749: WHERE payer.party_id = txn.payer_party_id
750: AND (payer.org_id is NULL OR (payer.org_id = txn.org_id AND payer.org_type = txn.org_type))
751: AND (payer.cust_account_id is NULL OR payer.cust_account_id = txn.cust_account_id)
752: AND (payer.acct_site_use_id is NULL OR payer.acct_site_use_id = txn.acct_site_use_id)

Line 862: 'UPDATE iby_trxn_summaries_all txn SET ' ||

858: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Update_Pmt_SRA_Attr_Prt';
859:
860: l_where_clause VARCHAR2(4000);
861: l_update_stmt VARCHAR2(4000) :=
862: 'UPDATE iby_trxn_summaries_all txn SET ' ||
863: ' debit_advice_delivery_method = ''PRINTED'', ' ||
864: ' debit_advice_email = null, ' ||
865: ' debit_advice_fax = null, ' ||
866: ' payer_notification_created = ''Y'', ' ||

Line 922: iby_trxn_summaries_all

918: BEGIN
919:
920: IF p_delivery_method = 'EMAIL' THEN
921: UPDATE
922: iby_trxn_summaries_all
923: SET
924: debit_advice_delivery_method = p_delivery_method,
925: debit_advice_email = p_recipient_email,
926: debit_advice_fax = null,

Line 935: iby_trxn_summaries_all

931: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
932: WHERE trxnmid = p_trxnmid;
933: ELSIF p_delivery_method = 'FAX' THEN
934: UPDATE
935: iby_trxn_summaries_all
936: SET
937: debit_advice_delivery_method = p_delivery_method,
938: debit_advice_email = null,
939: debit_advice_fax = p_recipient_fax,

Line 948: iby_trxn_summaries_all

944: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
945: WHERE trxnmid = p_trxnmid;
946: ELSIF p_delivery_method = 'PRINTED' THEN
947: UPDATE
948: iby_trxn_summaries_all
949: SET
950: debit_advice_delivery_method = p_delivery_method,
951: debit_advice_email = NULL,
952: debit_advice_fax = NULL,

Line 1011: FROM iby_trxn_summaries_all

1007: IF p_from_settlement_date IS NULL AND p_bep_type = 'PROCESSOR' THEN
1008: BEGIN
1009: SELECT MIN(reqdate)
1010: INTO l_reqdate
1011: FROM iby_trxn_summaries_all
1012: WHERE batchid = p_settlement_batch
1013: AND NVL(payer_notification_required, 'N') = 'Y';
1014: EXCEPTION
1015: WHEN others THEN NULL;