APPS.CE_AUTO_BANK_MATCH dependencies on CE_200_TRANSACTIONS_V

Line 377: FROM CE_200_TRANSACTIONS_V

373:
374: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches
375: CURSOR CHECK_AMOUNTS (X_batch_id NUMBER) IS
376: SELECT SUM(bank_account_amount)
377: FROM CE_200_TRANSACTIONS_V
378: --FROM ce_available_transactions_tmp
379: WHERE batch_id = X_batch_id
380: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
381: AND application_id = 200;

Line 402: FROM CE_200_TRANSACTIONS_V catv

398:
399:
400: CURSOR CHECK_group_AMOUNTS (X_batch_id NUMBER,X_LOGICAL_GROUP_REFERENCE VARCHAR2) IS
401: SELECT SUM(bank_account_amount)
402: FROM CE_200_TRANSACTIONS_V catv
403: WHERE batch_id = X_batch_id
404: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
405: AND application_id = 200
406: AND EXISTS ( SELECT 1

Line 2791: --FROM ce_200_transactions_v catv

2787: trx_cleared_amount_ap,
2788: no_of_currencies_ap,
2789: trx_curr_amount_ap,
2790: CE_AUTO_BANK_MATCH.csl_match_type
2791: --FROM ce_200_transactions_v catv
2792: FROM ce_available_transactions_tmp catv
2793: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2794: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
2795: AND catv.application_id = 200

Line 4336: --FROM ce_200_transactions_v catv

4332: CE_AUTO_BANK_MATCH.trx_cleared_date,
4333: CE_AUTO_BANK_MATCH.trx_org_id,
4334: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4335: CE_AUTO_BANK_MATCH.gt_seq_id
4336: --FROM ce_200_transactions_v catv
4337: FROM ce_available_transactions_tmp catv
4338: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4339: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4340: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 4390: --FROM ce_200_transactions_v catv

4386: CE_AUTO_BANK_MATCH.trx_cleared_date,
4387: CE_AUTO_BANK_MATCH.trx_org_id,
4388: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4389: CE_AUTO_BANK_MATCH.gt_seq_id
4390: --FROM ce_200_transactions_v catv
4391: FROM ce_available_transactions_tmp catv
4392: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4393: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4394: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)

Line 4809: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv

4805: v2.cleared_date,
4806: v2.org_id,
4807: v2.CE_BANK_ACCT_USE_ID,
4808: v2.seq_id
4809: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv
4810: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv
4811: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4812: AND nvl(catv.trx_number, '-99999') =
4813: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')

Line 5401: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,

5397: to_date(NULL),
5398: v2.org_id,
5399: v2.CE_BANK_ACCT_USE_ID,
5400: v2.seq_id
5401: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5402: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5403: ce_statement_headers h,
5404: ce_statement_reconcils_all r, ce_statement_lines l
5405: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 7960: cep_standard.debug('inserting data from ce_200_transactions_v');

7956: IF l_trx_source = 'AP' THEN
7957:
7958: IF CE_AUTO_BANK_MATCH.av_200_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
7959:
7960: cep_standard.debug('inserting data from ce_200_transactions_v');
7961:
7962: insert into ce_available_transactions_tmp
7963: (seq_id,
7964: ROW_ID,

Line 8101: from ce_200_transactions_v

8097: LEGAL_ENTITY_ID,
8098: ORG_ID,
8099: CE_BANK_ACCT_USE_ID,
8100: 'N'
8101: from ce_200_transactions_v
8102: where bank_account_id = p_bank_account_id;
8103:
8104: CE_AUTO_BANK_MATCH.av_200_inserted_flag := 'Y';
8105: END IF;