DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on PA_PROJECT_STATUSES

Line 148: ,pa_project_statuses pc

144: FROM pa_proj_element_versions pev_l
145: ,pa_lifecycle_usages plu
146: ,pa_proj_element_versions pev_p
147: ,pa_proj_elements ppe_p
148: ,pa_project_statuses pc
149: WHERE pev_l.object_type = 'PA_STRUCTURES'
150: AND pev_l.proj_element_id = p_lifecycle_id
151: AND pev_l.project_id = 0
152: AND plu.usage_type = 'PRODUCTS'

Line 205: ,pa_project_statuses pc

201: FROM pa_proj_element_versions pev_l
202: ,pa_lifecycle_usages plu
203: ,pa_proj_element_versions pev_p
204: ,pa_proj_elements ppe_p
205: ,pa_project_statuses pc
206: WHERE pev_l.object_type = 'PA_STRUCTURES'
207: AND pev_l.proj_element_id = p_lifecycle_id
208: AND pev_l.project_id = 0
209: AND plu.usage_type = 'PRODUCTS'