APPS.CE_AUTO_BANK_MATCH dependencies on CE_200_GROUPS_V

Line 3022: | matching group in payment from CE_200_GROUPS_V |

3018: | group_match |
3019: | |
3020: | DESCRIPTION |
3021: | Using the statement line transaction number, try to find a |
3022: | matching group in payment from CE_200_GROUPS_V |
3023: | FOR SEPA ER 6700007 |
3024: | CALLED BY |
3025: | match_line |
3026: --------------------------------------------------------------------- */

Line 3079: FROM CE_200_GROUPS_V ab

3075: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
3076: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
3077: CE_AUTO_BANK_MATCH.logical_group_reference,
3078: CE_AUTO_BANK_MATCH.csl_clearing_trx_type -- bug 7571492
3079: FROM CE_200_GROUPS_V ab
3080: WHERE upper(ab.logical_group_reference) = upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
3081: AND (ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
3082: or
3083: ab.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, ab.legal_entity_id))