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.CE_AUTO_BANK_CLEAR1 dependencies on CE_AVAILABLE_TRANSACTIONS_TMP

Line 20: FROM ce_available_transactions_tmp a

16: a.exchange_rate_date exchange_rate_date,
17: a.exchange_rate_type exchange_rate_type,
18: a.seq_id seq_id
19: --FROM ce_222_txn_for_batch_v a
20: FROM ce_available_transactions_tmp a
21: WHERE a.batch_id = rbatch_id
22: AND nvl(a.status, 'REMITTED') <> 'REVERSED'
23: AND a.application_id = 222
24: AND NVL(a.reconciled_status_flag, 'N') = 'N';

Line 40: --FROM ce_available_transactions_tmp a

36: a.exchange_rate_date exchange_rate_date,
37: a.exchange_rate_type exchange_rate_type,
38: a.org_id
39: FROM ce_222_txn_for_batch_v a
40: --FROM ce_available_transactions_tmp a
41: WHERE a.batch_id = rbatch_id
42: AND nvl(a.status, 'REMITTED') <> 'REVERSED';
43:
44: -- BUG 4435028 added CE trx to payment batches

Line 54: FROM ce_available_transactions_tmp a

50: 'PAYMENT' batch_trx_type,
51: a.cash_receipt_id batch_app_id,
52: a.seq_id seq_id
53: --FROM ce_200_transactions_v a
54: FROM ce_available_transactions_tmp a
55: WHERE a.batch_id = pbatch_id
56: AND nvl(a.status, 'NEGOTIABLE') <> 'VOIDED'
57: AND a.application_id = 200
58: AND NVL(a.reconciled_status_flag, 'N') = 'N'

Line 73: FROM ce_available_transactions_tmp a

69: 'CASHFLOW',
70: 673,
71: a.seq_id
72: --FROM ce_260_cf_transactions_v a
73: FROM ce_available_transactions_tmp a
74: WHERE a.batch_id = pbatch_id
75: AND nvl(a.status, 'CANCELED') <> 'CANCELED'
76: AND a.application_id = 261
77: AND NVL(a.reconciled_status_flag, 'N') = 'N'

Line 90: --FROM ce_available_transactions_tmp a

86: a.cash_receipt_id batch_app_id,
87: a.org_id org_id,
88: a.legal_entity_id legal_entity_id
89: FROM ce_200_transactions_v a
90: --FROM ce_available_transactions_tmp a
91: WHERE a.batch_id = pbatch_id
92: AND nvl(a.status, 'NEGOTIABLE') <> 'VOIDED'
93: -- FOR SEPA ER 6700007
94: AND EXISTS ( SELECT 1

Line 111: --FROM ce_available_transactions_tmp a

107: 673,
108: a.org_id,
109: a.legal_entity_id
110: FROM ce_260_cf_transactions_v a
111: --FROM ce_available_transactions_tmp a
112: WHERE a.batch_id = pbatch_id
113: AND nvl(a.status, 'CANCELED') <> 'CANCELED'
114: AND pgroup_id is null ; -- FOR SEPA ER 6700007
115: --AND a.application_id = 261;

Line 627: -- mark the transaction in ce_available_transactions_tmp as reconciled

623: trx_exchange_rate_type,
624: l_gt_seq_id;
625: EXIT WHEN rbatch_cursor%NOTFOUND OR rbatch_cursor%NOTFOUND IS NULL;
626:
627: -- mark the transaction in ce_available_transactions_tmp as reconciled
628: /*
629: IF l_gt_seq_id is not null THEN
630: update ce_available_transactions_tmp
631: set reconciled_status_flag = 'Y'

Line 630: update ce_available_transactions_tmp

626:
627: -- mark the transaction in ce_available_transactions_tmp as reconciled
628: /*
629: IF l_gt_seq_id is not null THEN
630: update ce_available_transactions_tmp
631: set reconciled_status_flag = 'Y'
632: where seq_id = l_gt_seq_id;
633: END IF;
634: */

Line 755: -- mark the transaction in ce_available_transactions_tmp as reconciled

751: Y_status_flag =>'M',
752: Y_amount => amount_to_clear);
753: END IF;
754:
755: -- mark the transaction in ce_available_transactions_tmp as reconciled
756: IF l_gt_seq_id is not null THEN
757: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
758: END IF;
759:

Line 1025: FROM ce_available_transactions_tmp catv

1021: SELECT catv.trx_id,
1022: catv.bank_account_amount,
1023: catv.seq_id
1024: --FROM ce_801_EFT_transactions_v catv
1025: FROM ce_available_transactions_tmp catv
1026: WHERE upper(catv.batch_name) =
1027: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1028: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1029: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 1093: -- mark the transaction in ce_available_transactions_tmp as reconciled

1089: END IF;
1090:
1091: EXIT WHEN pay_eft_cursor%NOTFOUND OR pay_eft_cursor%NOTFOUND IS NULL;
1092:
1093: -- mark the transaction in ce_available_transactions_tmp as reconciled
1094: /*
1095: IF l_gt_seq_id is not null THEN
1096: update ce_available_transactions_tmp
1097: set reconciled_status_flag = 'Y'

Line 1096: update ce_available_transactions_tmp

1092:
1093: -- mark the transaction in ce_available_transactions_tmp as reconciled
1094: /*
1095: IF l_gt_seq_id is not null THEN
1096: update ce_available_transactions_tmp
1097: set reconciled_status_flag = 'Y'
1098: where seq_id = l_gt_seq_id;
1099: END IF;
1100: */

Line 1141: -- mark the transaction in ce_available_transactions_tmp as reconciled

1137: Y_auto_reconciled_flag => auto_reconciled_flag,
1138: Y_status_flag => 'M',
1139: Y_amount => amount_to_clear);
1140:
1141: -- mark the transaction in ce_available_transactions_tmp as reconciled
1142: IF l_gt_seq_id is not null THEN
1143: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1144: END IF;
1145:

Line 1539: -- bug 5350073 ce_available_transactions_tmp is not populated when

1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1536: END IF;
1537: ------------------------------------------------------------------------
1538: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722
1539: -- bug 5350073 ce_available_transactions_tmp is not populated when
1540: -- manually reconcile IBY batches
1541: IF (passin_mode = 'AUTO' ) THEN
1542: cep_standard.debug('open pbatch_cursor');
1543:

Line 1549: -- mark the transaction in ce_available_transactions_tmp as reconciled

1545: LOOP
1546: FETCH pbatch_cursor INTO check_id, check_status, batch_trx_type, batch_app_id, l_gt_seq_id;
1547: EXIT WHEN pbatch_cursor%NOTFOUND OR pbatch_cursor%NOTFOUND IS NULL;
1548:
1549: -- mark the transaction in ce_available_transactions_tmp as reconciled
1550: /*
1551: IF l_gt_seq_id is not null THEN
1552: update ce_available_transactions_tmp
1553: set reconciled_status_flag = 'Y'

Line 1552: update ce_available_transactions_tmp

1548:
1549: -- mark the transaction in ce_available_transactions_tmp as reconciled
1550: /*
1551: IF l_gt_seq_id is not null THEN
1552: update ce_available_transactions_tmp
1553: set reconciled_status_flag = 'Y'
1554: where seq_id = l_gt_seq_id;
1555: END IF;
1556: */

Line 1571: -- mark the transaction in ce_available_transactions_tmp as reconciled

1567: Y_reference_status => check_status,
1568: Y_auto_reconciled_flag => auto_reconciled_flag,
1569: Y_status_flag => 'M');
1570:
1571: -- mark the transaction in ce_available_transactions_tmp as reconciled
1572: IF l_gt_seq_id is not null THEN
1573: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1574: END IF;
1575:

Line 2801: update ce_available_transactions_tmp

2797: cep_standard.debug('end call ARP_CASHBOOK.unclear');
2798: END IF;
2799:
2800: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2801: update ce_available_transactions_tmp
2802: set reconciled_status_flag = 'N'
2803: where application_id = 222
2804: and trx_id = trx_id
2805: and status <> 'REVERSED';

Line 3016: insert_stmt := 'INSERT INTO ce_available_transactions_tmp ' ||

3012: cursor_id INTEGER;
3013: exec_id INTEGER;
3014: BEGIN
3015: cursor_id := DBMS_SQL.open_cursor;
3016: insert_stmt := 'INSERT INTO ce_available_transactions_tmp ' ||
3017: '(ROW_ID, MULTI_SELECT, BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, ' ||
3018: 'BANK_ACCOUNT_NUM, BANK_NAME, BANK_BRANCH_NAME, '||
3019: 'TRX_ID, TRX_TYPE, TYPE_MEANING, TRX_NUMBER, CHECK_NUMBER, ' ||
3020: 'CURRENCY_CODE, AMOUNT, BANK_ACCOUNT_AMOUNT, AMOUNT_CLEARED, ' ||