[Home] [Help]
4774: | stmtline_match |
4775: | |
4776: | DESCRIPTION |
4777: | Using the statement line trx number, try to find a matching |
4778: | statement line from CE_260_TRANSACTIONS_V |
4779: | |
4780: | CALLED BY |
4781: | match_line |
4782: --------------------------------------------------------------------- */
4799: catv.exchange_rate,
4800: catv.exchange_rate_date,
4801: catv.exchange_rate_type,
4802: catv.seq_id
4803: --FROM ce_260_transactions_v catv
4804: FROM ce_available_transactions_tmp catv
4805: WHERE catv.trx_id <> CE_AUTO_BANK_MATCH.csl_statement_line_id
4806: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4807: AND nvl(catv.trx_number, '-99999') =
4863: v.cleared_date,
4864: v.org_id,
4865: v.CE_BANK_ACCT_USE_ID,
4866: v.seq_id
4867: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4868: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4869: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4870: AND nvl(catv.trx_number, '-99999') =
4871: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4964: v.cleared_date,
4965: v.org_id,
4966: v.CE_BANK_ACCT_USE_ID,
4967: v.seq_id
4968: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4969: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4970: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4971: AND nvl(catv.trx_number, '-99999') =
4972: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
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')
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');
8511:
8512: insert into ce_available_transactions_tmp
8513: (seq_id,
8514: ROW_ID,
8653: BANK_ACCOUNT_TEXT,
8654: CUSTOMER_TEXT,
8655: CE_BANK_ACCT_USE_ID,
8656: 'N'
8657: from ce_260_transactions_v
8658: where bank_account_id = p_bank_account_id;
8659:
8660: av_260_inserted_flag := 'Y';
8661: END IF;
9424: ELSIF l_trx_source = 'X' OR l_trx_source is null THEN
9425: IF l_trx_type IN ('MISC_CREDIT', 'MISC_DEBIT') THEN
9426: IF l_matching_against IN ('STMT', 'MS', 'SM') THEN
9427: IF CE_AUTO_BANK_MATCH.av_260_inserted_flag = 'N' THEN
9428: cep_standard.debug('inserting data from ce_260_transactions_v');
9429: insert into ce_available_transactions_tmp
9430: (seq_id,
9431: ROW_ID,
9432: MULTI_SELECT,
9570: BANK_ACCOUNT_TEXT,
9571: CUSTOMER_TEXT,
9572: CE_BANK_ACCT_USE_ID,
9573: 'N'
9574: from ce_260_transactions_v
9575: where bank_account_id = p_bank_account_id;
9576:
9577: CE_AUTO_BANK_MATCH.av_260_inserted_flag := 'Y';
9578: END IF; -- CE_AUTO_BANK_MATCH.av_260_inserted_flag = 'N'