eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_UPG_PPP_PKG dependencies on JG_ZZ_SYS_FORMATS_ALL_B

Line 892: FROM jg_zz_sys_formats_all_b sfa)

888: LENGTH(sfa.jgzz_country_code) + 2,
889: LENGTH(sfa.jgzz_attribute_category))
890: format_code,
891: sfa.org_id
892: FROM jg_zz_sys_formats_all_b sfa)
893: sfgdf,
894: iby_formats_b ipf,
895: iby_upg_ppp_b ppp,
896: iby_bepinfo bep,

Line 2623: FROM jg_zz_sys_formats_all_b sfa) sfgdf,

2619: SUBSTR(sfa.jgzz_attribute_category,
2620: LENGTH(sfa.jgzz_country_code)+2,
2621: LENGTH(sfa.jgzz_attribute_category)) format_code,
2622: sfa.org_id
2623: FROM jg_zz_sys_formats_all_b sfa) sfgdf,
2624: iby_formats_b ipf,
2625: iby_upg_ppp_b ppp,
2626: iby_bepinfo bep,
2627: iby_bepkeys key

Line 2927: FROM jg_zz_sys_formats_all_b sfa) sfgdf,

2923: (SELECT SUBSTR(sfa.jgzz_attribute_category,
2924: LENGTH(sfa.jgzz_country_code)+2,
2925: LENGTH(sfa.jgzz_attribute_category)) format_code,
2926: sfa.org_id
2927: FROM jg_zz_sys_formats_all_b sfa) sfgdf,
2928: hr_organization_units ou
2929: WHERE cf.format_payments_program_id = pp.program_id
2930: AND pp.program_name = ipf.reference_format_code
2931: AND ipf.format_type_code = 'OUTBOUND_PAYMENT_INSTRUCTION'