Change Order Life Cycle Phase Query

Summary: We are trying to identify the life cycle of red lined items in the change order before the change order is approved and scheduled.

Attached are the screenshots of an example change order. In the Items table, when queried with change Line ID, we do not have any records. Could you please suggest which table will have these redline life cycle phase details.

Version (include the version you are using, if applicable):24B

Code Snippet (add any code snippets that support your topic, if applicable):

Query:

SELECT eec.change_notice
,ecl.pk1_value
,ecl.sequence_number
,ecl.new_item_revision_id