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 766: -- mark the transaction in ce_available_transactions_tmp as reconciled

762: Y_status_flag =>'M',
763: Y_amount => amount_to_clear);
764: END IF;
765:
766: -- mark the transaction in ce_available_transactions_tmp as reconciled
767: IF l_gt_seq_id is not null THEN
768: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
769: END IF;
770:

Line 1046: FROM ce_available_transactions_tmp catv

1042: SELECT catv.trx_id,
1043: catv.bank_account_amount,
1044: catv.seq_id
1045: --FROM ce_801_EFT_transactions_v catv
1046: FROM ce_available_transactions_tmp catv
1047: WHERE upper(LTrim(catv.batch_name)) = /*12733547 added ltrim on batch number*/
1048: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1049: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1050: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

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

1110: END IF;
1111:
1112: EXIT WHEN pay_eft_cursor%NOTFOUND OR pay_eft_cursor%NOTFOUND IS NULL;
1113:
1114: -- mark the transaction in ce_available_transactions_tmp as reconciled
1115: /*
1116: IF l_gt_seq_id is not null THEN
1117: update ce_available_transactions_tmp
1118: set reconciled_status_flag = 'Y'

Line 1117: update ce_available_transactions_tmp

1113:
1114: -- mark the transaction in ce_available_transactions_tmp as reconciled
1115: /*
1116: IF l_gt_seq_id is not null THEN
1117: update ce_available_transactions_tmp
1118: set reconciled_status_flag = 'Y'
1119: where seq_id = l_gt_seq_id;
1120: END IF;
1121: */

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

1158: Y_auto_reconciled_flag => auto_reconciled_flag,
1159: Y_status_flag => 'M',
1160: Y_amount => amount_to_clear);
1161:
1162: -- mark the transaction in ce_available_transactions_tmp as reconciled
1163: IF l_gt_seq_id is not null THEN
1164: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1165: END IF;
1166:

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

1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1567: END IF;
1568: ------------------------------------------------------------------------
1569: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722
1570: -- bug 5350073 ce_available_transactions_tmp is not populated when
1571: -- manually reconcile IBY batches
1572: IF (passin_mode = 'AUTO' ) THEN
1573: cep_standard.debug('open pbatch_cursor');
1574:

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

1576: LOOP
1577: FETCH pbatch_cursor INTO check_id, check_status, batch_trx_type, batch_app_id, l_gt_seq_id;
1578: EXIT WHEN pbatch_cursor%NOTFOUND OR pbatch_cursor%NOTFOUND IS NULL;
1579:
1580: -- mark the transaction in ce_available_transactions_tmp as reconciled
1581: /*
1582: IF l_gt_seq_id is not null THEN
1583: update ce_available_transactions_tmp
1584: set reconciled_status_flag = 'Y'

Line 1583: update ce_available_transactions_tmp

1579:
1580: -- mark the transaction in ce_available_transactions_tmp as reconciled
1581: /*
1582: IF l_gt_seq_id is not null THEN
1583: update ce_available_transactions_tmp
1584: set reconciled_status_flag = 'Y'
1585: where seq_id = l_gt_seq_id;
1586: END IF;
1587: */

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

1598: Y_reference_status => check_status,
1599: Y_auto_reconciled_flag => auto_reconciled_flag,
1600: Y_status_flag => 'M');
1601:
1602: -- mark the transaction in ce_available_transactions_tmp as reconciled
1603: IF l_gt_seq_id is not null THEN
1604: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1605: END IF;
1606:

Line 2888: update ce_available_transactions_tmp

2884: cep_standard.debug('end call ARP_CASHBOOK.unclear');
2885: END IF;
2886:
2887: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2888: update ce_available_transactions_tmp
2889: set reconciled_status_flag = 'N'
2890: where application_id = 222
2891: and trx_id = trx_id
2892: and status <> 'REVERSED';

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

3101: cursor_id INTEGER;
3102: exec_id INTEGER;
3103: BEGIN
3104: cursor_id := DBMS_SQL.open_cursor;
3105: insert_stmt := 'INSERT INTO ce_available_transactions_tmp ' ||
3106: '(ROW_ID, MULTI_SELECT, BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, ' ||
3107: 'BANK_ACCOUNT_NUM, BANK_NAME, BANK_BRANCH_NAME, '||
3108: 'TRX_ID, TRX_TYPE, TYPE_MEANING, TRX_NUMBER, CHECK_NUMBER, ' ||
3109: 'CURRENCY_CODE, AMOUNT, BANK_ACCOUNT_AMOUNT, AMOUNT_CLEARED, ' ||