APPS.CE_AUTO_BANK_MATCH dependencies on CE_260_CF_TRANSACTIONS_V

Line 1644: --FROM ce_260_cf_transactions_v catv

1640: catv.cleared_date,
1641: catv.deposit_date,
1642: catv.legal_entity_id,
1643: catv.seq_id
1644: --FROM ce_260_cf_transactions_v catv
1645: FROM ce_available_transactions_tmp catv
1646: WHERE catv.trx_type = tx_type
1647: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1648: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id , catv.legal_entity_id)

Line 1678: --FROM ce_260_cf_transactions_v catv

1674: catv.cleared_date,
1675: catv.deposit_date,
1676: catv.legal_entity_id,
1677: catv.seq_id
1678: --FROM ce_260_cf_transactions_v catv
1679: FROM ce_available_transactions_tmp catv
1680: WHERE catv.trx_type = tx_type
1681: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1682: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)

Line 1715: --FROM ce_260_cf_transactions_v catv

1711: catv.cleared_date,
1712: catv.deposit_date,
1713: catv.legal_entity_id,
1714: catv.seq_id
1715: --FROM ce_260_cf_transactions_v catv
1716: FROM ce_available_transactions_tmp catv
1717: WHERE catv.trx_type = tx_type
1718: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1719: --AND catv.legal_entity_id = CE_AUTO_BANK_REC.G_legal_entity_id

Line 2816: --FROM ce_260_cf_transactions_v catv

2812: trx_cleared_amount_ce,
2813: no_of_currencies_ce,
2814: trx_curr_amount_ce,
2815: CE_AUTO_BANK_MATCH.csl_match_type
2816: --FROM ce_260_cf_transactions_v catv
2817: FROM ce_available_transactions_tmp catv
2818: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2819: AND nvl(catv.status, 'CANCELED') <> 'CANCELED'
2820: AND catv.application_id = 261

Line 7607: --FROM ce_260_cf_transactions_v catv

7603: CE_AUTO_BANK_MATCH.trx_exchange_rate_date,
7604: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
7605: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
7606: CE_AUTO_BANK_MATCH.gt_seq_id
7607: --FROM ce_260_cf_transactions_v catv
7608: FROM ce_available_transactions_tmp catv
7609: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7610: AND catv.TRX_ID = CE_AUTO_BANK_MATCH.csl_cashflow_id
7611: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,catv.legal_entity_id)

Line 7771: -- if so, populate from ce_260_cf_transactions_v,

7767: -- clean up the temp table
7768: delete ce_available_transactions_tmp;
7769:
7770: -- first check if there's any stmt line that has cashflow_id
7771: -- if so, populate from ce_260_cf_transactions_v,
7772: -- this is because in autoreconciliation, if a line has cashflow_id,
7773: -- before everything else, it'll match to cashflow transactions
7774:
7775: select count(1)

Line 7785: cep_standard.debug('inserting data from ce_260_cf_transactions_v');

7781: and sl.cashflow_id is not null;
7782:
7783: IF l_cf > 0 THEN -- some line has cashflow_id
7784: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
7785: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
7786: insert into ce_available_transactions_tmp
7787: (seq_id,
7788: ROW_ID,
7789: MULTI_SELECT,

Line 7935: from ce_260_cf_transactions_v

7931: COUNTERPARTY,
7932: TRXN_SUBTYPE,
7933: CE_BANK_ACCT_USE_ID,
7934: 'N'
7935: from ce_260_cf_transactions_v
7936: where bank_account_id = p_bank_account_id;
7937:
7938: CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag := 'Y';
7939: END IF; --CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N'

Line 8258: -- when l_trx_source is 'CE', only populate from ce_260_cf_transactions_v

8254: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
8255: END IF;
8256:
8257: ELSIF l_trx_source = 'CE' THEN
8258: -- when l_trx_source is 'CE', only populate from ce_260_cf_transactions_v
8259: /*
8260: IF av_260_inserted_flag = 'N' THEN
8261:
8262: cep_standard.debug('inserting data from ce_260_transactions_v');

Line 8416: cep_standard.debug('inserting data from ce_260_cf_transactions_v');

8412: av_260_inserted_flag := 'Y';
8413: END IF;
8414: */
8415: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
8416: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
8417: insert into ce_available_transactions_tmp
8418: (seq_id,
8419: ROW_ID,
8420: MULTI_SELECT,

Line 8566: from ce_260_cf_transactions_v

8562: COUNTERPARTY,
8563: TRXN_SUBTYPE,
8564: CE_BANK_ACCT_USE_ID,
8565: 'N'
8566: from ce_260_cf_transactions_v
8567: where bank_account_id = p_bank_account_id;
8568:
8569: CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag := 'Y';
8570: END IF;