APPS.CE_AUTO_BANK_MATCH dependencies on CE_999_TRANSACTIONS_V

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

830: END IF;
831:
832: -- no xtr match from above query
833: IF ( CE_AUTO_BANK_MATCH.trx_id is null) THEN
834: cep_standard.debug( ' use ce_999_transactions_v ' );
835:
836: SELECT catv.trx_id,
837: catv.cash_receipt_id,
838: catv.row_id,

Line 878: --FROM ce_999_transactions_v catv

874: CE_AUTO_BANK_MATCH.trx_org_id,
875: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
876: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
877: CE_AUTO_BANK_MATCH.gt_seq_id
878: --FROM ce_999_transactions_v catv
879: FROM ce_available_transactions_tmp catv
880: WHERE catv.trx_type = tx_type
881: --AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
882: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

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

4130:
4131: -- If above treasury query is not able to find a matching transaction, find in external data through CE_999 objects
4132: IF (CE_AUTO_BANK_MATCH.trx_id IS NULL)
4133: THEN -- Bug 12699623 End
4134: cep_standard.debug('use ce_999_transactions_v ' );
4135: SELECT
4136: catv.trx_id,
4137: catv.cash_receipt_id,
4138: catv.row_id,

Line 4176: -- ce_999_transactions_v catv

4172: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
4173: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
4174: CE_AUTO_BANK_MATCH.gt_seq_id
4175: FROM
4176: -- ce_999_transactions_v catv
4177: ce_available_transactions_tmp catv
4178: WHERE
4179: catv.trx_type = tx_type
4180: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

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

8972:
8973: ELSIF l_trx_source = 'OI' THEN
8974:
8975: -- Bug 7356199 removed the inserting data from ce_185_transactions_v
8976: -- as ce_999_transactions_v consists a union of ce_185_transactions_v
8977: IF CE_AUTO_BANK_MATCH.av_999_inserted_flag = 'N' THEN
8978:
8979: cep_standard.debug('inserting data from ce_999_transactions_v');
8980:

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

8975: -- Bug 7356199 removed the inserting data from ce_185_transactions_v
8976: -- as ce_999_transactions_v consists a union of ce_185_transactions_v
8977: IF CE_AUTO_BANK_MATCH.av_999_inserted_flag = 'N' THEN
8978:
8979: cep_standard.debug('inserting data from ce_999_transactions_v');
8980:
8981: insert into ce_available_transactions_tmp
8982: (seq_id,
8983: ROW_ID,

Line 9120: from ce_999_transactions_v

9116: LEGAL_ENTITY_ID,
9117: ORG_ID,
9118: CE_BANK_ACCT_USE_ID,
9119: 'N'
9120: from ce_999_transactions_v
9121: where bank_account_id = p_bank_account_id;
9122:
9123: CE_AUTO_BANK_MATCH.av_999_inserted_flag := 'Y';
9124: END IF;