APPS.CE_AUTO_BANK_MATCH dependencies on CE_222_TRANSACTIONS_V

Line 4205: --FROM ce_222_transactions_v catv

4201: NVL(catv.reversed_receipt_flag, 'N'),
4202: catv.org_id,
4203: catv.CE_BANK_ACCT_USE_ID,
4204: catv.seq_id
4205: --FROM ce_222_transactions_v catv
4206: FROM ce_available_transactions_tmp catv
4207: WHERE DECODE(tx_type,'CASH',
4208: DECODE(catv.trx_type,'MISC',
4209: 'CASH',

Line 4269: --FROM ce_222_transactions_v catv

4265: CE_AUTO_BANK_MATCH.trx_gl_date ,
4266: CE_AUTO_BANK_MATCH.trx_org_id,
4267: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4268: CE_AUTO_BANK_MATCH.gt_seq_id
4269: --FROM ce_222_transactions_v catv
4270: FROM ce_available_transactions_tmp catv
4271: WHERE DECODE(tx_type,'CASH',
4272: DECODE(catv.trx_type,'MISC',
4273: 'CASH',

Line 4620: --FROM ce_222_transactions_v v, ce_260_transactions_v catv

4616: v.cleared_date,
4617: v.org_id,
4618: v.CE_BANK_ACCT_USE_ID,
4619: v.seq_id
4620: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4621: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4622: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4623: AND nvl(catv.trx_number, '-99999') =
4624: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')

Line 4721: --FROM ce_222_transactions_v v, ce_260_transactions_v catv

4717: v.cleared_date,
4718: v.org_id,
4719: v.CE_BANK_ACCT_USE_ID,
4720: v.seq_id
4721: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4722: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4723: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4724: AND nvl(catv.trx_number, '-99999') =
4725: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')

Line 5286: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,

5282: ar.trx_date,
5283: v.org_id,
5284: v.CE_BANK_ACCT_USE_ID,
5285: v.seq_id
5286: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5287: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5288: ar_cash_receipt_history_all ar, ce_statement_headers h,
5289: ce_statement_reconcils_all r, ce_statement_lines l
5290: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 6445: --from ce_222_transactions_v

6441:
6442: begin
6443: select 'Y'
6444: into misc_exists
6445: --from ce_222_transactions_v
6446: from ce_available_transactions_tmp
6447: where trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF'
6448: and trx_type = 'MISC'
6449: and rownum = 1

Line 8110: cep_standard.debug('inserting data from ce_222_transactions_v');

8106:
8107: ELSIF l_trx_source = 'AR' THEN
8108:
8109: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
8110: cep_standard.debug('inserting data from ce_222_transactions_v');
8111:
8112: insert into ce_available_transactions_tmp
8113: (seq_id,
8114: ROW_ID,

Line 8251: from ce_222_transactions_v

8247: LEGAL_ENTITY_ID,
8248: ORG_ID,
8249: CE_BANK_ACCT_USE_ID,
8250: 'N'
8251: from ce_222_transactions_v
8252: where bank_account_id = p_bank_account_id;
8253:
8254: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
8255: END IF;

Line 9336: cep_standard.debug('inserting data from ce_222_transactions_v');

9332: END IF; -- l_matching_against
9333:
9334: IF l_matching_against IN ('MISC', 'MS', 'SM') THEN
9335: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9336: cep_standard.debug('inserting data from ce_222_transactions_v');
9337: insert into ce_available_transactions_tmp
9338: (seq_id,
9339: ROW_ID,
9340: MULTI_SELECT,

Line 9476: from ce_222_transactions_v

9472: LEGAL_ENTITY_ID,
9473: ORG_ID,
9474: CE_BANK_ACCT_USE_ID,
9475: 'N'
9476: from ce_222_transactions_v
9477: where bank_account_id = p_bank_account_id;
9478:
9479: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
9480: END IF; -- CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N'

Line 9485: cep_standard.debug('inserting data from ce_222_transactions_v');

9481: END IF; -- l_matching_against
9482:
9483: ELSIF l_trx_type IN ('REJECTED', 'NSF') THEN
9484: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9485: cep_standard.debug('inserting data from ce_222_transactions_v');
9486:
9487: insert into ce_available_transactions_tmp
9488: (seq_id,
9489: ROW_ID,

Line 9626: from ce_222_transactions_v

9622: LEGAL_ENTITY_ID,
9623: ORG_ID,
9624: CE_BANK_ACCT_USE_ID,
9625: 'N'
9626: from ce_222_transactions_v
9627: where bank_account_id = p_bank_account_id;
9628:
9629: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
9630: END IF; -- av_222_inserted_flag = 'N'