APPS.CE_AUTO_BANK_MATCH dependencies on CE_200_TRANSACTIONS_V

Line 358: FROM CE_200_TRANSACTIONS_V

354:
355: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches
356: CURSOR CHECK_AMOUNTS (X_batch_id NUMBER) IS
357: SELECT SUM(bank_account_amount)
358: FROM CE_200_TRANSACTIONS_V
359: --FROM ce_available_transactions_tmp
360: WHERE batch_id = X_batch_id
361: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
362: AND application_id = 200;

Line 383: FROM CE_200_TRANSACTIONS_V catv

379:
380:
381: CURSOR CHECK_group_AMOUNTS (X_batch_id NUMBER,X_LOGICAL_GROUP_REFERENCE VARCHAR2) IS
382: SELECT SUM(bank_account_amount)
383: FROM CE_200_TRANSACTIONS_V catv
384: WHERE batch_id = X_batch_id
385: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
386: AND application_id = 200
387: AND EXISTS ( SELECT 1

Line 2794: -- ce_200_transactions_v

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

Line 4498: --ce_200_transactions_v catv

4494: CE_AUTO_BANK_MATCH.trx_org_id,
4495: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4496: CE_AUTO_BANK_MATCH.gt_seq_id
4497: FROM
4498: --ce_200_transactions_v catv
4499: ce_available_transactions_tmp catv
4500: WHERE
4501: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4502: AND catv.check_number = to_number(LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0'))

Line 4554: --ce_200_transactions_v catv

4550: CE_AUTO_BANK_MATCH.trx_org_id,
4551: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4552: CE_AUTO_BANK_MATCH.gt_seq_id
4553: FROM
4554: --ce_200_transactions_v catv
4555: ce_available_transactions_tmp catv
4556: WHERE
4557: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4558: AND catv.org_id = CE_AUTO_BANK_REC.G_org_id

Line 4615: -- ce_200_transactions_v catv

4611: CE_AUTO_BANK_MATCH.trx_org_id,
4612: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4613: CE_AUTO_BANK_MATCH.gt_seq_id
4614: FROM
4615: -- ce_200_transactions_v catv
4616: ce_available_transactions_tmp catv
4617: WHERE
4618: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4619: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)

Line 5056: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv

5052: v2.cleared_date,
5053: v2.org_id,
5054: v2.CE_BANK_ACCT_USE_ID,
5055: v2.seq_id
5056: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv
5057: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv
5058: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5059: AND nvl(catv.trx_number, '-99999') =
5060: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')

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

5644: to_date(NULL),
5645: v2.org_id,
5646: v2.CE_BANK_ACCT_USE_ID,
5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

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

8204: IF l_trx_source = 'AP' THEN
8205:
8206: IF CE_AUTO_BANK_MATCH.av_200_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
8207:
8208: cep_standard.debug('inserting data from ce_200_transactions_v');
8209:
8210: insert into ce_available_transactions_tmp
8211: (seq_id,
8212: ROW_ID,

Line 8349: from ce_200_transactions_v

8345: LEGAL_ENTITY_ID,
8346: ORG_ID,
8347: CE_BANK_ACCT_USE_ID,
8348: 'N'
8349: from ce_200_transactions_v
8350: where bank_account_id = p_bank_account_id;
8351:
8352: CE_AUTO_BANK_MATCH.av_200_inserted_flag := 'Y';
8353: END IF;