APPS.CE_AUTO_BANK_MATCH dependencies on CE_222_TRANSACTIONS_V

Line 4363: -- ce_222_transactions_v catv

4359: catv.org_id,
4360: catv.CE_BANK_ACCT_USE_ID,
4361: catv.seq_id
4362: FROM
4363: -- ce_222_transactions_v catv
4364: ce_available_transactions_tmp catv
4365: WHERE
4366: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4367: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 4424: -- ce_222_transactions_v catv

4420: CE_AUTO_BANK_MATCH.trx_org_id,
4421: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4422: CE_AUTO_BANK_MATCH.gt_seq_id
4423: FROM
4424: -- ce_222_transactions_v catv
4425: ce_available_transactions_tmp catv
4426: WHERE
4427: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4428: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 4867: --FROM ce_222_transactions_v v, ce_260_transactions_v catv

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')

Line 4968: --FROM ce_222_transactions_v v, ce_260_transactions_v catv

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')

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

5529: ar.trx_date,
5530: v.org_id,
5531: v.CE_BANK_ACCT_USE_ID,
5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 6666: --FROM ce_222_transactions_v

6662: THEN
6663: BEGIN
6664: SELECT 'Y'
6665: INTO misc_exists
6666: --FROM ce_222_transactions_v
6667: FROM ce_available_transactions_tmp
6668: WHERE trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF'
6669: AND trx_type = 'MISC'
6670: AND rownum = 1

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

8354:
8355: ELSIF l_trx_source = 'AR' THEN
8356:
8357: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
8358: cep_standard.debug('inserting data from ce_222_transactions_v');
8359:
8360: insert into ce_available_transactions_tmp
8361: (seq_id,
8362: ROW_ID,

Line 8499: from ce_222_transactions_v

8495: LEGAL_ENTITY_ID,
8496: ORG_ID,
8497: CE_BANK_ACCT_USE_ID,
8498: 'N'
8499: from ce_222_transactions_v
8500: where bank_account_id = p_bank_account_id;
8501:
8502: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
8503: END IF;

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

9580: END IF; -- l_matching_against
9581:
9582: IF l_matching_against IN ('MISC', 'MS', 'SM') THEN
9583: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9584: cep_standard.debug('inserting data from ce_222_transactions_v');
9585: insert into ce_available_transactions_tmp
9586: (seq_id,
9587: ROW_ID,
9588: MULTI_SELECT,

Line 9724: from ce_222_transactions_v

9720: LEGAL_ENTITY_ID,
9721: ORG_ID,
9722: CE_BANK_ACCT_USE_ID,
9723: 'N'
9724: from ce_222_transactions_v
9725: where bank_account_id = p_bank_account_id;
9726:
9727: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
9728: END IF; -- CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N'

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

9729: END IF; -- l_matching_against
9730:
9731: ELSIF l_trx_type IN ('REJECTED', 'NSF') THEN
9732: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9733: cep_standard.debug('inserting data from ce_222_transactions_v');
9734:
9735: insert into ce_available_transactions_tmp
9736: (seq_id,
9737: ROW_ID,

Line 9874: from ce_222_transactions_v

9870: LEGAL_ENTITY_ID,
9871: ORG_ID,
9872: CE_BANK_ACCT_USE_ID,
9873: 'N'
9874: from ce_222_transactions_v
9875: where bank_account_id = p_bank_account_id;
9876:
9877: CE_AUTO_BANK_MATCH.av_222_inserted_flag := 'Y';
9878: END IF; -- av_222_inserted_flag = 'N'