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

Line 120: iby_trxn_summaries_all ts,

116: tc.instr_owner_country,
117: tc.shipfromzip,
118: tc.shiptozip
119: from iby_batches_all b,
120: iby_trxn_summaries_all ts,
121: iby_trxn_core tc
122: where b.mbatchid = P_MBATCH_ID
123: and b.mbatchid = ts.mbatchid
124: and ts.trxnmid = tc.trxnmid;

Line 283: iby_trxn_summaries_all ts,

279: tc.instr_owner_country,
280: tc.shipfromzip,
281: tc.shiptozip
282: from iby_batches_all b,
283: iby_trxn_summaries_all ts,
284: iby_trxn_core tc
285: where b.mbatchid = P_MBATCH_ID
286: and b.mbatchid = ts.mbatchid
287: and ts.trxnmid = tc.trxnmid;

Line 348: iby_trxn_summaries_all

344: bepkey
345: INTO
346: l_bepkey
347: FROM
348: iby_trxn_summaries_all
349: WHERE mbatchid = P_MBATCH_ID
350: AND rownum=1;
351:
352: /*

Line 646: iby_trxn_summaries_all ts,

642: tc.instr_owner_country,
643: tc.shipfromzip,
644: tc.shiptozip
645: from iby_batches_all b,
646: iby_trxn_summaries_all ts,
647: iby_trxn_core tc
648: where b.mbatchid = P_MBATCH_ID
649: and b.mbatchid = ts.mbatchid
650: and ts.trxnmid = tc.trxnmid;

Line 1022: ,iby_trxn_summaries_all ts

1018: -- Cursor for settlement records.
1019: cursor c_settle_trxns is
1020: select ts.trxnmid
1021: from iby_batches_all b
1022: ,iby_trxn_summaries_all ts
1023: where b.mbatchid = P_MBATCH_ID
1024: and b.mbatchid = ts.mbatchid ;
1025:
1026: -- Cursor to retrieve the certain mandate params.

Line 1027: cursor c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)

1023: where b.mbatchid = P_MBATCH_ID
1024: and b.mbatchid = ts.mbatchid ;
1025:
1026: -- Cursor to retrieve the certain mandate params.
1027: cursor c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)
1028: is
1029: select da.authorization_reference_number
1030: ,da.auth_sign_date
1031: ,da.creditor_legal_entity_id

Line 1036: from iby_trxn_summaries_all ts

1032: ,da.creditor_identifier
1033: ,da.cust_addr_id
1034: ,da.creditor_le_name
1035: ,da.external_bank_account_use_id
1036: from iby_trxn_summaries_all ts
1037: ,iby_debit_authorizations da
1038: where ts.trxnmid = ci_trxnmid
1039: and ts.debit_authorization_id = da.debit_authorization_id
1040: -- and da.auth_cancel_date is NULL

Line 1047: ( ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE )

1043: and da.curr_rec_indi = 'Y' ;
1044:
1045: -- Cursor to retrieve the account option values.
1046: cursor c_acct_option_vals
1047: ( ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE )
1048: is
1049: select vals.account_option_code
1050: ,vals.account_option_value
1051: from iby_trxn_summaries_all ts

Line 1051: from iby_trxn_summaries_all ts

1047: ( ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE )
1048: is
1049: select vals.account_option_code
1050: ,vals.account_option_value
1051: from iby_trxn_summaries_all ts
1052: ,iby_bepkeys keys
1053: ,iby_bep_acct_opt_vals vals
1054: ,iby_payee payee
1055: where ts.trxnmid = ci_trxnmid

Line 1065: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;

1061: -- and vals.account_option_code = ci_acct_option_code;
1062: and vals.account_option_code in ('SEPA_INITIATING_PARTY_ID' , 'SEPA_INITIATING_PARTY_ID_ISSR'
1063: ,'SEPA_INITIATING_PARTY_NAME' ,'SEPA_BATCH_BOOKING' );
1064:
1065: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
1066:
1067: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1068: l_auth_sign_date iby_debit_authorizations.auth_sign_date%TYPE;
1069: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;

Line 1376: from iby_trxn_summaries_all

1372: update iby_debit_authorizations
1373: set debit_auth_flag = 'N' , debit_auth_end = sysdate
1374: where debit_authorization_id in
1375: ( select debit_authorization_id
1376: from iby_trxn_summaries_all
1377: where trxntypeid = 100
1378: and instrtype = 'BANKACCOUNT'
1379: and mbatchid = P_MBATCH_ID
1380: and seq_type in ('FNAL', 'OOFF')

Line 1413: iby_trxn_summaries_all ts

1409: CURSOR c_settle_trxns
1410: IS
1411: SELECT ts.trxnmid
1412: FROM iby_batches_all b ,
1413: iby_trxn_summaries_all ts
1414: WHERE b.mbatchid = P_MBATCH_ID
1415: AND b.mbatchid = ts.mbatchid ;
1416: -- Cursor to retrieve the certain mandate params.
1417: CURSOR c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)

Line 1417: CURSOR c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)

1413: iby_trxn_summaries_all ts
1414: WHERE b.mbatchid = P_MBATCH_ID
1415: AND b.mbatchid = ts.mbatchid ;
1416: -- Cursor to retrieve the certain mandate params.
1417: CURSOR c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)
1418: IS
1419: SELECT da.authorization_reference_number
1420: FROM iby_trxn_summaries_all ts ,
1421: iby_debit_authorizations da

Line 1420: FROM iby_trxn_summaries_all ts ,

1416: -- Cursor to retrieve the certain mandate params.
1417: CURSOR c_mandate(ci_trxnmid IN iby_trxn_summaries_all.trxnmid%TYPE)
1418: IS
1419: SELECT da.authorization_reference_number
1420: FROM iby_trxn_summaries_all ts ,
1421: iby_debit_authorizations da
1422: WHERE ts.trxnmid = ci_trxnmid
1423: AND ts.debit_authorization_id = da.debit_authorization_id
1424: AND NVL(da.auth_cancel_date,sysdate) >= ts.settledate

Line 1428: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;

1424: AND NVL(da.auth_cancel_date,sysdate) >= ts.settledate
1425: AND NVL(da.debit_auth_end,sysdate) >= ts.settledate
1426: AND NVL(da.auth_sign_date,sysdate) <= ts.settledate
1427: AND da.curr_rec_indi = 'Y' ;
1428: l_trxnmid iby_trxn_summaries_all.trxnmid%TYPE;
1429: l_auth_reference_number iby_debit_authorizations.authorization_reference_number%TYPE;
1430: BEGIN
1431: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1432: print_debuginfo(G_DEBUG_MODULE, 'Entered ... ');