[Home] [Help]
4527: | stmtline_match |
4528: | |
4529: | DESCRIPTION |
4530: | Using the statement line trx number, try to find a matching |
4531: | statement line from CE_260_TRANSACTIONS_V |
4532: | |
4533: | CALLED BY |
4534: | match_line |
4535: --------------------------------------------------------------------- */
4552: catv.exchange_rate,
4553: catv.exchange_rate_date,
4554: catv.exchange_rate_type,
4555: catv.seq_id
4556: --FROM ce_260_transactions_v catv
4557: FROM ce_available_transactions_tmp catv
4558: WHERE catv.trx_id <> CE_AUTO_BANK_MATCH.csl_statement_line_id
4559: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4560: AND nvl(catv.trx_number, '-99999') =
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')
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')
4805: v2.cleared_date,
4806: v2.org_id,
4807: v2.CE_BANK_ACCT_USE_ID,
4808: v2.seq_id
4809: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv
4810: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv
4811: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4812: AND nvl(catv.trx_number, '-99999') =
4813: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
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');
8263:
8264: insert into ce_available_transactions_tmp
8265: (seq_id,
8266: ROW_ID,
8405: BANK_ACCOUNT_TEXT,
8406: CUSTOMER_TEXT,
8407: CE_BANK_ACCT_USE_ID,
8408: 'N'
8409: from ce_260_transactions_v
8410: where bank_account_id = p_bank_account_id;
8411:
8412: av_260_inserted_flag := 'Y';
8413: END IF;
9176: ELSIF l_trx_source = 'X' OR l_trx_source is null THEN
9177: IF l_trx_type IN ('MISC_CREDIT', 'MISC_DEBIT') THEN
9178: IF l_matching_against IN ('STMT', 'MS', 'SM') THEN
9179: IF CE_AUTO_BANK_MATCH.av_260_inserted_flag = 'N' THEN
9180: cep_standard.debug('inserting data from ce_260_transactions_v');
9181: insert into ce_available_transactions_tmp
9182: (seq_id,
9183: ROW_ID,
9184: MULTI_SELECT,
9322: BANK_ACCOUNT_TEXT,
9323: CUSTOMER_TEXT,
9324: CE_BANK_ACCT_USE_ID,
9325: 'N'
9326: from ce_260_transactions_v
9327: where bank_account_id = p_bank_account_id;
9328:
9329: CE_AUTO_BANK_MATCH.av_260_inserted_flag := 'Y';
9330: END IF; -- CE_AUTO_BANK_MATCH.av_260_inserted_flag = 'N'