2873: for providing the flexiblity to the customers
2874: Bug Number: 7532799*/
2875: DECODE(sfgdf.org_id,
2876: NULL, cf.name|| Decode(ppb.system_profile_code, 'IBY_PAY_EFT_German_General', ' General Payments',
2877: 'IBY_PAY_EFT_German_EU_Standard', ' EU Standard Payments',
2878: 'IBY_PAY_EFT_German_EUE', ' EUE Payments',
2879: '')
2880: || Decode(ipf.format_code, 'IBY_PAY_CHK_DE_A', '(Stub after Payment)',
2881: 'IBY_PAY_CHK_FORM_FEED_1A', '(Stub after Payment)',
2881: 'IBY_PAY_CHK_FORM_FEED_1A', '(Stub after Payment)',
2882: 'IBY_PAY_CHK_FORM_FEED_2A', '(Stub after Payment)',
2883: 'IBY_PAY_CHK_FR_A', '(Stub after Payment)',
2884: 'IBY_PAY_CHK_LASER_A', '(Stub after Payment)',
2885: 'IBY_PAY_CHK_STANDARD_1A', '(Stub after Payment)',
2886: 'IBY_PAY_CHK_STANDARD_2A', '(Stub after Payment)',
2887: ''),
2888: cf.name|| Decode(ppb.system_profile_code, 'IBY_PAY_EFT_German_General', ' General Payments',
2889: 'IBY_PAY_EFT_German_EU_Standard', ' EU Standard Payments',
2882: 'IBY_PAY_CHK_FORM_FEED_2A', '(Stub after Payment)',
2883: 'IBY_PAY_CHK_FR_A', '(Stub after Payment)',
2884: 'IBY_PAY_CHK_LASER_A', '(Stub after Payment)',
2885: 'IBY_PAY_CHK_STANDARD_1A', '(Stub after Payment)',
2886: 'IBY_PAY_CHK_STANDARD_2A', '(Stub after Payment)',
2887: ''),
2888: cf.name|| Decode(ppb.system_profile_code, 'IBY_PAY_EFT_German_General', ' General Payments',
2889: 'IBY_PAY_EFT_German_EU_Standard', ' EU Standard Payments',
2890: 'IBY_PAY_EFT_German_EUE', ' EUE Payments',
2885: 'IBY_PAY_CHK_STANDARD_1A', '(Stub after Payment)',
2886: 'IBY_PAY_CHK_STANDARD_2A', '(Stub after Payment)',
2887: ''),
2888: cf.name|| Decode(ppb.system_profile_code, 'IBY_PAY_EFT_German_General', ' General Payments',
2889: 'IBY_PAY_EFT_German_EU_Standard', ' EU Standard Payments',
2890: 'IBY_PAY_EFT_German_EUE', ' EUE Payments',
2891: '')
2892: ||' - '||ou.name
2893: || Decode(ipf.format_code, 'IBY_PAY_CHK_DE_A', '(Stub after Payment)',
2894: 'IBY_PAY_CHK_FORM_FEED_1A', '(Stub after Payment)',
2895: 'IBY_PAY_CHK_FORM_FEED_2A', '(Stub after Payment)',
2896: 'IBY_PAY_CHK_FR_A', '(Stub after Payment)',
2897: 'IBY_PAY_CHK_LASER_A', '(Stub after Payment)',
2898: 'IBY_PAY_CHK_STANDARD_1A', '(Stub after Payment)',
2899: 'IBY_PAY_CHK_STANDARD_2A', '(Stub after Payment)',
2900: '')
2901: ) system_profile_name,
2902: pp.friendly_name system_profile_description,
2895: 'IBY_PAY_CHK_FORM_FEED_2A', '(Stub after Payment)',
2896: 'IBY_PAY_CHK_FR_A', '(Stub after Payment)',
2897: 'IBY_PAY_CHK_LASER_A', '(Stub after Payment)',
2898: 'IBY_PAY_CHK_STANDARD_1A', '(Stub after Payment)',
2899: 'IBY_PAY_CHK_STANDARD_2A', '(Stub after Payment)',
2900: '')
2901: ) system_profile_name,
2902: pp.friendly_name system_profile_description,
2903: ppp.language language_code,