APPS.CE_AUTO_BANK_MATCH dependencies on CE_260_CF_TRANSACTIONS_V

Line 1659: --FROM ce_260_cf_transactions_v catv

1655: catv.cleared_date,
1656: catv.deposit_date,
1657: catv.legal_entity_id,
1658: catv.seq_id
1659: --FROM ce_260_cf_transactions_v catv
1660: FROM ce_available_transactions_tmp catv
1661: WHERE catv.trx_type = tx_type
1662: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1663: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id , catv.legal_entity_id)

Line 1693: --FROM ce_260_cf_transactions_v catv

1689: catv.cleared_date,
1690: catv.deposit_date,
1691: catv.legal_entity_id,
1692: catv.seq_id
1693: --FROM ce_260_cf_transactions_v catv
1694: FROM ce_available_transactions_tmp catv
1695: WHERE catv.trx_type = tx_type
1696: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1697: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)

Line 1730: --FROM ce_260_cf_transactions_v catv

1726: catv.cleared_date,
1727: catv.deposit_date,
1728: catv.legal_entity_id,
1729: catv.seq_id
1730: --FROM ce_260_cf_transactions_v catv
1731: FROM ce_available_transactions_tmp catv
1732: WHERE catv.trx_type = tx_type
1733: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1734: --AND catv.legal_entity_id = CE_AUTO_BANK_REC.G_legal_entity_id

Line 2822: -- ce_260_cf_transactions_v catv

2818: trx_curr_amount_ce,
2819: CE_AUTO_BANK_MATCH.csl_match_type
2820: FROM
2821: ce_available_transactions_tmp catv
2822: -- ce_260_cf_transactions_v catv
2823: WHERE
2824: catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2825: AND nvl(catv.status, 'CANCELED') <> 'CANCELED'
2826: AND catv.application_id = 261

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

8015: -- clean up the temp table
8016: delete ce_available_transactions_tmp;
8017:
8018: -- first check if there's any stmt line that has cashflow_id
8019: -- if so, populate from ce_260_cf_transactions_v,
8020: -- this is because in autoreconciliation, if a line has cashflow_id,
8021: -- before everything else, it'll match to cashflow transactions
8022:
8023: select count(1)

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

8029: and sl.cashflow_id is not null;
8030:
8031: IF l_cf > 0 THEN -- some line has cashflow_id
8032: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
8033: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
8034: insert into ce_available_transactions_tmp
8035: (seq_id,
8036: ROW_ID,
8037: MULTI_SELECT,

Line 8183: from ce_260_cf_transactions_v

8179: COUNTERPARTY,
8180: TRXN_SUBTYPE,
8181: CE_BANK_ACCT_USE_ID,
8182: 'N'
8183: from ce_260_cf_transactions_v
8184: where bank_account_id = p_bank_account_id;
8185:
8186: CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag := 'Y';
8187: END IF; --CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N'

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

8502: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
8503: END IF;
8504:
8505: ELSIF l_trx_source = 'CE' THEN
8506: -- when l_trx_source is 'CE', only populate from ce_260_cf_transactions_v
8507: /*
8508: IF av_260_inserted_flag = 'N' THEN
8509:
8510: cep_standard.debug('inserting data from ce_260_transactions_v');

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

8660: av_260_inserted_flag := 'Y';
8661: END IF;
8662: */
8663: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
8664: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
8665: insert into ce_available_transactions_tmp
8666: (seq_id,
8667: ROW_ID,
8668: MULTI_SELECT,

Line 8814: from ce_260_cf_transactions_v

8810: COUNTERPARTY,
8811: TRXN_SUBTYPE,
8812: CE_BANK_ACCT_USE_ID,
8813: 'N'
8814: from ce_260_cf_transactions_v
8815: where bank_account_id = p_bank_account_id;
8816:
8817: CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag := 'Y';
8818: END IF;