DBA Data[Home] [Help]

APPS.ENG_DEFAULT_REVISED_ITEM dependencies on ENG_CHANGE_STATUSES_VL

Line 397: FROM eng_change_statuses_vl ecsv

393:
394: CURSOR c_status (cp_change_id IN NUMBER)
395: IS
396: SELECT ecsv.status_code , ecsv.status_type
397: FROM eng_change_statuses_vl ecsv
398: WHERE ecsv.status_code IN (SELECT els1.status_code
399: FROM eng_lifecycle_statuses els1
400: WHERE els1.entity_name='ENG_CHANGE'
401: AND els1.entity_id1 = cp_change_id

Line 1362: FROM eng_change_statuses_vl ecsv

1358:
1359: CURSOR c_status (cp_change_id IN NUMBER)
1360: IS
1361: SELECT ecsv.status_code
1362: FROM eng_change_statuses_vl ecsv
1363: WHERE ecsv.status_code IN (SELECT els1.status_code
1364: FROM eng_lifecycle_statuses els1
1365: WHERE els1.entity_name='ENG_CHANGE'
1366: AND els1.entity_id1 = cp_change_id