APPS.INV_EGO_REVISION_VALIDATE dependencies on EGO_LCPHASE_ITEM_STATUS

Line 265: FROM ego_lcphase_item_status status

261: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
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);

Line 363: FROM ego_lcphase_item_status status

359: AND NVL(approval_status,'A') <> 'A'
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);