DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on ENG_LIFECYCLE_STATUSES

Line 149: (select status_code from eng_lifecycle_statuses

145: ) is
146: SELECT status_code ,status_type
147: from eng_change_statuses_vl
148: where status_code in
149: (select status_code from eng_lifecycle_statuses
150: where entity_name='ENG_CHANGE_TYPE'
151: and entity_id1 = p_change_order_type_id
152: and sequence_number =
153: (select min(sequence_number) from eng_lifecycle_statuses

Line 153: (select min(sequence_number) from eng_lifecycle_statuses

149: (select status_code from eng_lifecycle_statuses
150: where entity_name='ENG_CHANGE_TYPE'
151: and entity_id1 = p_change_order_type_id
152: and sequence_number =
153: (select min(sequence_number) from eng_lifecycle_statuses
154: where entity_name='ENG_CHANGE_TYPE'
155: and entity_id1 = p_change_order_type_id)
156: );
157: