APPS.CE_AUTO_BANK_MATCH dependencies on CE_200_GROUPS_V

Line 2961: | matching group in payment from CE_200_GROUPS_V |

2957: | group_match |
2958: | |
2959: | DESCRIPTION |
2960: | Using the statement line transaction number, try to find a |
2961: | matching group in payment from CE_200_GROUPS_V |
2962: | FOR SEPA ER 6700007 |
2963: | CALLED BY |
2964: | match_line |
2965: --------------------------------------------------------------------- */

Line 3013: FROM CE_200_GROUPS_V ab

3009: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
3010: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
3011: CE_AUTO_BANK_MATCH.logical_group_reference,
3012: CE_AUTO_BANK_MATCH.csl_clearing_trx_type -- bug 7571492
3013: FROM CE_200_GROUPS_V ab
3014: WHERE upper(ab.logical_group_reference) = upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
3015: AND (ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
3016: or
3017: ab.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, ab.legal_entity_id))