APPS.INV_EGO_REVISION_VALIDATE dependencies on PA_EGO_PHASES_V

Line 266: ,pa_ego_phases_v phase

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

Line 364: ,pa_ego_phases_v phase

360: )
361: --4932389 : Perf fixes for lifecycle-phase-status queries.
362: OR EXISTS (SELECT NULL
363: FROM ego_lcphase_item_status status
364: ,pa_ego_phases_v phase
365: WHERE status.phase_code = phase.phase_code
366: AND proj_element_id = cp_phase_id
367: AND status.item_status_code = cp_status_code);
368:

Line 373: FROM pa_ego_phases_v

369: --Promote/Demote only to the immediate phase before/after current -Bug5375723
370: Cursor c_display_seq_phase(cp_phase_id NUMBER)
371: IS
372: SELECT display_sequence
373: FROM pa_ego_phases_v
374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;