APPS.INV_EGO_REVISION_VALIDATE dependencies on EGO_LCPHASE_ITEM_STATUS

Line 261: FROM ego_lcphase_item_status status

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

Line 379: FROM ego_lcphase_item_status status

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