apps.ap_inv_selection_critereia_all returns no rows
When I query ap.ap_inv_selection_criteria_all or ap.ap_inv_selection_criteria_all#, they both return rows. When I query apps.ap_inv_selection_criteria_all, it returns no rows but it is a synonym based on ap.ap_inv_selection_criteria_all#. To get data back from the apps.ap_inv_selection_critieria_all, do you have to set the environment? If so, how?
I ran these three queries using the same value for &ppr_name:
select * from apps.AP_INV_SELECTION_CRITERIA_ALL where checkrun_name = '&ppr_name'; --this returns no rows
select * from ap.ap_inv_selection_criteria_all where checkrun_name = '&ppr_name'; -- this returns 1 row