DBA Data[Home] [Help]

APPS.IBY_UPG_PPP_PKG dependencies on AP_CHECK_STOCKS_ALL

Line 800: ap_check_stocks_all cs,

796: (cf.check_format_id) || '_' || sfgdf.org_id))
797: system_profile_code
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(

Line 2431: FROM ap_check_stocks_all cs

2427: cf.last_update_login,
2428: (CASE
2429: WHEN ppp.processing_type = 'PRINTED' THEN
2430: (SELECT cs.check_stock_id
2431: FROM ap_check_stocks_all cs
2432: WHERE (cs.inactive_date IS NULL OR
2433: TRUNC(cs.inactive_date) >= TRUNC(sysdate))
2434: AND cs.check_format_id = cf.check_format_id
2435: AND ROWNUM=1)

Line 2562: ap_check_stocks_all cs,

2558: rank() over (partition by cf.check_format_id, sfgdf.org_id, cs.bank_account_id
2559: order by cs.check_stock_id, key.bep_account_id) create_intba
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