Report Manager - How to identify EPMDocuments which are checked-out/awaiting promotion request

[ptc-184557]

We have created a query with Report Manager (Windchill 9.0 M020) that identifies all EPMDocumentMaster objects where name and number don't match. Here's the sql:

SELECT A0.name C1C0, A0.documentNumber C1C1, A0.CADName C1C2, A0.classnameA2A2, A0.idA2A2

FROM EPMDocumentMaster A0

WHERE (((A0.name A0.CADName)))

ORDER BY NLSSORT (C1C1, 'NLS_SORT = ASCII7')

I would like toalsodetermine if any of the objects returned are "checked-out" or "awaiting promotion request".Does anyone have a report that does something similar or know which tables/attributes contain this information?

Thanks,

Mary Mitchell

[ptc-184557]

Many thanks to Stephen B!

In the EPMDocument table "statestate" = "under review" returns objects awaiting promotion request and "status.state" = "checked out" returns objects that are checked out. Here is the updated sql:

For Checked_out:

SELECT A0.name C1C0, A0.documentNumber C1C1, A0.CADName C1C2, A0.classnameA2A2, A0.idA2A2, A1.statecheckoutInfo C1C4

FROM EPMDocumentMaster A0, EPMDocument A1

WHERE (((A0.name A0.CADName) AND (A1.statecheckoutInfo = ?) AND (A1.idA3masterReference = A0.idA2A2)))

ORDER BY NLSSORT (C1C1, 'NLS_SORT = ASCII7')

[c/o]

For Awaiting Promotion Request

SELECT A0.name C1C0, A0.documentNumber C1C1, A0.CADName C1C2, A0.classnameA2A2, A0.idA2A2, A1.statestate C1C4

FROM EPMDocumentMaster A0, EPMDocument A1

WHERE (((A0.name A0.CADName) AND (A1.statestate = ?) AND (A1.idA3masterReference = A0.idA2A2)))

ORDER BY NLSSORT (C1C1, 'NLS_SORT = ASCII7')

[UNDERREVIEW]