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 249: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||

245: l_extract_query VARCHAR2(4000) :=
246: 'select XMLElement("FundsCapturePayerNotification", ' ||
247: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||
248: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||
249: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
250: ' where txn.trxnmid = xml_order.trxnmid ' ||
251: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
252:
253: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;

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

249: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
250: ' where txn.trxnmid = xml_order.trxnmid ' ||
251: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
252:
253: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;
254: -- l_mbatchid VARCHAR2(100);
255: -- l_toDate VARCHAR2(100);
256: -- l_delivery_method VARCHAR2(30);
257: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;

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

253: -- l_trxn_id iby_trxn_summaries_all.trxnmid%TYPE;
254: -- l_mbatchid VARCHAR2(100);
255: -- l_toDate VARCHAR2(100);
256: -- l_delivery_method VARCHAR2(30);
257: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;
258: -- l_toPSON iby_trxn_summaries_all.tangibleid%TYPE;
259:
260: BEGIN
261:

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

254: -- l_mbatchid VARCHAR2(100);
255: -- l_toDate VARCHAR2(100);
256: -- l_delivery_method VARCHAR2(30);
257: -- l_fromPSON iby_trxn_summaries_all.tangibleid%TYPE;
258: -- l_toPSON iby_trxn_summaries_all.tangibleid%TYPE;
259:
260: BEGIN
261:
262: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

Line 569: iby_trxn_summaries_all txn,

565: )--,
566: --txn.mbatchid,
567: --txn.payeeinstrid
568: FROM
569: iby_trxn_summaries_all txn,
570: iby_payee payee,
571: iby_bepkeys keys,
572: iby_xml_fndcpt_bankaccount_v xml_bank,
573: iby_xml_bep_acct_options_v opts,

Line 648: iby_trxn_summaries_all txn,

644: )--,
645: --txn.mbatchid,
646: --txn.payeeinstrid
647: FROM
648: iby_trxn_summaries_all txn,
649: iby_payee payee,
650: iby_bepkeys keys,
651: iby_xml_fndcpt_bankaccount_v xml_bank,
652: iby_xml_bep_acct_options_v opts,

Line 734: FROM iby_trxn_summaries_all txn, iby_batches_all bat

730: l_email_sub VARCHAR2(200);
731:
732: CURSOR l_instrument_type_csr (p_trxnmid IN NUMBER) IS
733: SELECT bat.instrument_type
734: FROM iby_trxn_summaries_all txn, iby_batches_all bat
735: WHERE txn.trxnmid = p_trxnmid
736: AND txn.mbatchid = bat.mbatchid;
737:
738: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS

Line 741: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

737:
738: CURSOR l_eft_sra_setup_csr (p_trxnmid IN NUMBER) IS
739: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
740: sys_pf.payer_notification_format, sys_pf.PAYER_NOTIFICATION_CONDITION, sys_pf.PN_COND_NUM_OF_RECEIPTS
741: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
742: iby_fndcpt_sys_eft_pf_b sys_pf, iby_fndcpt_user_eft_pf_b user_pf
743: WHERE txn.trxnmid = p_trxnmid
744: AND txn.mbatchid = bat.mbatchid
745: AND bat.process_profile_code = user_pf.user_eft_profile_code

Line 751: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

747:
748: CURSOR l_cc_sra_setup_csr (p_trxnmid IN NUMBER) IS
749: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
750: sys_pf.payer_notification_format, sys_pf.PAYER_NOTIFICATION_CONDITION, sys_pf.PN_COND_NUM_OF_RECEIPTS
751: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
752: iby_fndcpt_sys_cc_pf_b sys_pf, iby_fndcpt_user_cc_pf_b user_pf
753: WHERE txn.trxnmid = p_trxnmid
754: AND txn.mbatchid = bat.mbatchid
755: AND bat.process_profile_code = user_pf.user_cc_profile_code

Line 761: FROM iby_trxn_summaries_all txn, iby_batches_all bat,

757:
758: CURSOR l_dc_sra_setup_csr (p_trxnmid IN NUMBER) IS
759: SELECT sys_pf.OVERRIDE_PAYER_DELIVERY_FLAG, sys_pf.PAYER_NOTIFICATION_DEL_METHOD,
760: sys_pf.payer_notification_format, sys_pf.PAYER_NOTIFICATION_CONDITION, sys_pf.PN_COND_NUM_OF_RECEIPTS
761: FROM iby_trxn_summaries_all txn, iby_batches_all bat,
762: iby_fndcpt_sys_dc_pf_b sys_pf, iby_fndcpt_user_dc_pf_b user_pf
763: WHERE txn.trxnmid = p_trxnmid
764: AND txn.mbatchid = bat.mbatchid
765: AND bat.process_profile_code = user_pf.user_dc_profile_code

Line 771: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,

767:
768: CURSOR l_lang_territory_csr (p_trxnmid IN NUMBER) IS
769: SELECT loc.language, loc.country
770: FROM hz_party_sites ps, hz_locations loc,
771: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,
772: hz_cust_acct_sites_all hz_cs
773: where txn.trxnmid = p_trxnmid
774: and hz_csu.cust_acct_site_id = hz_cs.cust_acct_site_id
775: and hz_cs.party_site_id = ps.party_site_id

Line 781: FROM IBY_TRXN_SUMMARIES_ALL

777: AND loc.location_id = ps.location_id;
778:
779: CURSOR l_settle_ref_csr(p_trxnmid IN NUMBER) Is
780: SELECT tangibleid
781: FROM IBY_TRXN_SUMMARIES_ALL
782: WHERE TRXNMID = p_trxnmid;
783:
784:
785: BEGIN

Line 889: iby_trxn_summaries_all txn

885: SELECT payer.debit_advice_delivery_method,
886: payer.debit_advice_email,
887: payer.debit_advice_fax
888: FROM iby_external_payers_all payer,
889: iby_trxn_summaries_all txn
890: WHERE payer.party_id = txn.payer_party_id
891: AND (payer.org_id is NULL OR (payer.org_id = txn.org_id AND payer.org_type = txn.org_type))
892: AND (payer.cust_account_id is NULL OR payer.cust_account_id = txn.cust_account_id)
893: AND (payer.acct_site_use_id is NULL OR payer.acct_site_use_id = txn.acct_site_use_id)

Line 1003: 'UPDATE iby_trxn_summaries_all txn SET ' ||

999: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Update_Pmt_SRA_Attr_Prt';
1000:
1001: l_where_clause VARCHAR2(4000);
1002: l_update_stmt VARCHAR2(4000) :=
1003: 'UPDATE iby_trxn_summaries_all txn SET ' ||
1004: ' debit_advice_delivery_method = ''PRINTED'', ' ||
1005: ' debit_advice_email = null, ' ||
1006: ' debit_advice_fax = null, ' ||
1007: ' payer_notification_created = ''Y'', ' ||

Line 1063: iby_trxn_summaries_all

1059: BEGIN
1060:
1061: IF p_delivery_method = 'EMAIL' THEN
1062: UPDATE
1063: iby_trxn_summaries_all
1064: SET
1065: debit_advice_delivery_method = p_delivery_method,
1066: debit_advice_email = p_recipient_email,
1067: debit_advice_fax = null,

Line 1076: iby_trxn_summaries_all

1072: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1073: WHERE trxnmid = p_trxnmid;
1074: ELSIF p_delivery_method = 'FAX' THEN
1075: UPDATE
1076: iby_trxn_summaries_all
1077: SET
1078: debit_advice_delivery_method = p_delivery_method,
1079: debit_advice_email = null,
1080: debit_advice_fax = p_recipient_fax,

Line 1089: iby_trxn_summaries_all

1085: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1086: WHERE trxnmid = p_trxnmid;
1087: ELSIF p_delivery_method = 'PRINTED' THEN
1088: UPDATE
1089: iby_trxn_summaries_all
1090: SET
1091: debit_advice_delivery_method = p_delivery_method,
1092: debit_advice_email = NULL,
1093: debit_advice_fax = NULL,

Line 1152: FROM iby_trxn_summaries_all

1148: IF p_from_settlement_date IS NULL AND p_bep_type = 'PROCESSOR' THEN
1149: BEGIN
1150: SELECT MIN(reqdate)
1151: INTO l_reqdate
1152: FROM iby_trxn_summaries_all
1153: WHERE batchid = p_settlement_batch
1154: AND NVL(payer_notification_required, 'N') = 'Y';
1155: EXCEPTION
1156: WHEN others THEN NULL;

Line 1445: l_payment_channel_code IBY_TRXN_SUMMARIES_ALL.PAYMENT_CHANNEL_CODE%TYPE;

1441: rec_limit NUMBER := 1000;
1442: l_doc_headers_rec Doc_headers_rec_type;
1443: l_DocHeadersTab DocHeadersTabType;
1444: l_count NUMBER;
1445: l_payment_channel_code IBY_TRXN_SUMMARIES_ALL.PAYMENT_CHANNEL_CODE%TYPE;
1446: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Insert_Into_Headers_Gt';
1447: BEGIN
1448:
1449: IF (l_header_cursor%ISOPEN) THEN CLOSE l_header_cursor; END IF;

Line 1456: FROM iby_trxn_summaries_all txn

1452: has null for ship_from_address_id
1453: */
1454: SELECT payment_channel_code
1455: INTO l_payment_channel_code
1456: FROM iby_trxn_summaries_all txn
1457: WHERE txn.mbatchid = p_txn_id
1458: AND rownum = 1;
1459:
1460: l_headers_query := 'SELECT

Line 1510: iby_trxn_summaries_all txn

1506: l_headers_query := l_headers_query || 'ar_docs_receivables_v inv_header,';
1507: END IF;
1508:
1509: l_headers_query := l_headers_query ||'hz_locations to_loc,
1510: iby_trxn_summaries_all txn
1511: WHERE txn.initiator_extension_id = inv_header.order_ext_id
1512: AND(txn.trxntypeid IN(''8'', ''9'', ''100''))
1513: AND(inv_header.ship_to_address_id = to_loc.location_id(+))
1514: AND(txn.mbatchid = :1)';

Line 1550: l_payment_channel_code IBY_TRXN_SUMMARIES_ALL.PAYMENT_CHANNEL_CODE%TYPE;

1546: rec_limit NUMBER := 1000;
1547: l_doc_lines_rec Doc_lines_rec_type;
1548: l_DocLinesTab DocLinesTabType;
1549: l_count NUMBER;
1550: l_payment_channel_code IBY_TRXN_SUMMARIES_ALL.PAYMENT_CHANNEL_CODE%TYPE;
1551: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Insert_Into_Lines_Gt';
1552: BEGIN
1553:
1554: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Enter , TimeStamp:' ||systimestamp);

Line 1559: FROM iby_trxn_summaries_all txn

1555: IF (l_lines_cursor%ISOPEN) THEN CLOSE l_lines_cursor; END IF;
1556:
1557: SELECT payment_channel_code
1558: INTO l_payment_channel_code
1559: FROM iby_trxn_summaries_all txn
1560: WHERE txn.mbatchid = p_txn_id
1561: AND rownum = 1;
1562:
1563: l_lines_query := 'SELECT

Line 1592: iby_trxn_summaries_all txn

1588: l_lines_query := l_lines_query || 'ar_document_lines_v inv_line,';
1589: END IF;
1590:
1591: l_lines_query := l_lines_query || 'ar_docs_receivables_v inv_header,
1592: iby_trxn_summaries_all txn
1593: WHERE(inv_header.doc_unique_ref = inv_line.doc_unique_ref(+))
1594: AND(txn.initiator_extension_id = inv_header.order_ext_id)
1595: AND(txn.trxntypeid IN(''8'', ''9'', ''100''))
1596: AND(txn.mbatchid = :1)';