466: IS
467: SELECT f.format_name,
468: f.format_code
469: FROM IBY_PAYMENT_PROFILES p,
470: IBY_FORMATS_VL f,
471: IBY_APPLICABLE_PMT_PROFS apf,
472: IBY_APPLICABLE_PMT_PROFS apm,
473: IBY_PAYMENT_METHODS_B m
474: WHERE f.format_code = p.payment_format_code
1938: r.territory_code payment_reason_country
1939: FROM IBY_EXTERNAL_PAYEES_ALL payee,
1940: IBY_EXT_PARTY_PMT_MTHDS pm,
1941: IBY_PAYMENT_METHODS_VL m,
1942: IBY_FORMATS_VL f,
1943: IBY_DELIVERY_CHANNELS_VL d,
1944: IBY_PAYMENT_REASONS_VL r,
1945: IBY_APPLICABLE_PMT_MTHDS am1,
1946: IBY_APPLICABLE_PMT_MTHDS am2,
2016: d.territory_code delivery_channel_country,
2017: r.territory_code payment_reason_country
2018: FROM
2019: IBY_EXTERNAL_PAYEES_ALL payee,
2020: IBY_FORMATS_VL f,
2021: IBY_DELIVERY_CHANNELS_VL d,
2022: IBY_PAYMENT_REASONS_VL r
2023: WHERE
2024: payee.ext_payee_id IN