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 AP_PAYMENT_PROGRAMS

Line 802: ap_payment_programs pp,

798: FROM
799: ap_check_formats cf,
800: ap_check_stocks_all cs,
801: ce_upg_bank_accounts cba,
802: ap_payment_programs pp,
803: jg_zz_pay_format_info gdf,
804: (SELECT(
805: CASE
806: WHEN sfa.jgzz_attribute_category =

Line 932: FROM ap_check_formats cf, ap_payment_programs pp

928: iby_bepkeys key1
929: WHERE(ipf.reference_format_code IS NULL OR(ipf.reference_format_code IS NOT NULL
930: AND ipf.reference_format_code NOT IN
931: (SELECT pp.program_name
932: FROM ap_check_formats cf, ap_payment_programs pp
933: WHERE cf.format_payments_program_id = pp.program_id)))
934: AND ppb.payment_format_code = ipf.format_code
935: AND ipf.format_type_code = 'OUTBOUND_PAYMENT_INSTRUCTION'
936: AND ppp.system_profile_code = app.system_profile_code

Line 2564: ap_payment_programs pp,

2560: FROM
2561: ap_check_formats cf,
2562: ap_check_stocks_all cs,
2563: ce_upg_bank_accounts cba,
2564: ap_payment_programs pp,
2565: jg_zz_pay_format_info gdf,
2566: (SELECT (CASE
2567: WHEN sfa.jgzz_attribute_category = 'SE.JESEPBAI' THEN
2568: sfa.jgzz_system_info5

Line 2776: ap_payment_programs pp

2772: WHERE (ipf.reference_format_code IS NULL OR
2773: (ipf.reference_format_code IS NOT NULL AND
2774: ipf.reference_format_code NOT IN (SELECT pp.program_name
2775: FROM ap_check_formats cf,
2776: ap_payment_programs pp
2777: WHERE cf.format_payments_program_id = pp.program_id))
2778: )
2779: AND ppp.payment_format_code = ipf.format_code
2780: AND ipf.format_type_code = 'OUTBOUND_PAYMENT_INSTRUCTION'

Line 2916: ap_payment_programs pp,

2912: rank() over (partition by app.system_profile_code
2913: order by app.payment_profile_id) create_header
2914: FROM
2915: ap_check_formats cf,
2916: ap_payment_programs pp,
2917: iby_formats_b ipf,
2918: iby_upg_ppp_tl ppp,
2919: iby_upg_ppp_b ppb,
2920: iby_acct_pmt_profiles_b app,

Line 2969: ap_payment_programs pp

2965: WHERE (ipf.reference_format_code IS NULL OR
2966: (ipf.reference_format_code IS NOT NULL AND
2967: ipf.reference_format_code NOT IN (SELECT pp.program_name
2968: FROM ap_check_formats cf,
2969: ap_payment_programs pp
2970: WHERE cf.format_payments_program_id = pp.program_id))
2971: )
2972: AND ppb.payment_format_code = ipf.format_code
2973: AND ipf.format_type_code = 'OUTBOUND_PAYMENT_INSTRUCTION'