APPS.INV_EGO_REVISION_VALIDATE dependencies on PA_EGO_PHASES_V

Line 262: ,pa_ego_phases_v phase

258: AND item_Catalog_group_id = P_Catalog_Group_Id)
259: --4932389 : Perf fixes for lifecycle-phase-status queries.
260: OR EXISTS (SELECT NULL
261: FROM ego_lcphase_item_status status
262: ,pa_ego_phases_v phase
263: WHERE status.phase_code = phase.phase_code
264: AND proj_element_id = cp_phase_id
265: AND status.item_status_code = cp_status_code);
266:

Line 380: ,pa_ego_phases_v phase

376: )
377: --4932389 : Perf fixes for lifecycle-phase-status queries.
378: OR EXISTS (SELECT NULL
379: FROM ego_lcphase_item_status status
380: ,pa_ego_phases_v phase
381: WHERE status.phase_code = phase.phase_code
382: AND proj_element_id = cp_phase_id
383: AND status.item_status_code = cp_status_code);
384:

Line 389: FROM pa_ego_phases_v

385: --Promote/Demote only to the immediate phase before/after current -Bug5375723
386: Cursor c_display_seq_phase(cp_phase_id NUMBER)
387: IS
388: SELECT display_sequence
389: FROM pa_ego_phases_v
390: WHERE proj_element_id = cp_phase_id ;
391:
392: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
393: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;