APPS.CE_AUTO_BANK_MATCH dependencies on CE_999_TRANSACTIONS_V

Line 822: cep_standard.debug( ' use ce_999_transactions_v ' );

818: END IF;
819:
820: -- no xtr match from above query
821: IF ( CE_AUTO_BANK_MATCH.trx_id is null) THEN
822: cep_standard.debug( ' use ce_999_transactions_v ' );
823:
824: SELECT catv.trx_id,
825: catv.cash_receipt_id,
826: catv.row_id,

Line 866: --FROM ce_999_transactions_v catv

862: CE_AUTO_BANK_MATCH.trx_org_id,
863: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
864: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
865: CE_AUTO_BANK_MATCH.gt_seq_id
866: --FROM ce_999_transactions_v catv
867: FROM ce_available_transactions_tmp catv
868: WHERE catv.trx_type = tx_type
869: --AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
870: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 3984: cep_standard.debug('use ce_999_transactions_v ' );

3980: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
3981: AND catv.application_id = 185
3982: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
3983: ELSE -- no LE_ID or not XTR acct
3984: cep_standard.debug('use ce_999_transactions_v ' );
3985:
3986: SELECT catv.trx_id,
3987: catv.cash_receipt_id,
3988: catv.row_id,

Line 4024: --FROM ce_999_transactions_v catv

4020: CE_AUTO_BANK_MATCH.trx_exchange_rate_date,
4021: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
4022: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
4023: CE_AUTO_BANK_MATCH.gt_seq_id
4024: --FROM ce_999_transactions_v catv
4025: FROM ce_available_transactions_tmp catv
4026: WHERE catv.trx_type = tx_type
4027: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4028: --AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_REC.G_legal_entity_id)

Line 8728: -- as ce_999_transactions_v consists a union of ce_185_transactions_v

8724:
8725: ELSIF l_trx_source = 'OI' THEN
8726:
8727: -- Bug 7356199 removed the inserting data from ce_185_transactions_v
8728: -- as ce_999_transactions_v consists a union of ce_185_transactions_v
8729: IF CE_AUTO_BANK_MATCH.av_999_inserted_flag = 'N' THEN
8730:
8731: cep_standard.debug('inserting data from ce_999_transactions_v');
8732:

Line 8731: cep_standard.debug('inserting data from ce_999_transactions_v');

8727: -- Bug 7356199 removed the inserting data from ce_185_transactions_v
8728: -- as ce_999_transactions_v consists a union of ce_185_transactions_v
8729: IF CE_AUTO_BANK_MATCH.av_999_inserted_flag = 'N' THEN
8730:
8731: cep_standard.debug('inserting data from ce_999_transactions_v');
8732:
8733: insert into ce_available_transactions_tmp
8734: (seq_id,
8735: ROW_ID,

Line 8872: from ce_999_transactions_v

8868: LEGAL_ENTITY_ID,
8869: ORG_ID,
8870: CE_BANK_ACCT_USE_ID,
8871: 'N'
8872: from ce_999_transactions_v
8873: where bank_account_id = p_bank_account_id;
8874:
8875: CE_AUTO_BANK_MATCH.av_999_inserted_flag := 'Y';
8876: END IF;