3 Replies Latest reply on Dec 25, 2019 7:44 AM by Ivy Zhu-Oracle

    PLM4P - Table Names/Query required to update yellow locks in Formulation Specification

    P Subrahmanyam

      As per user requirement, need to update the yellow locks from open to close for the specifications which are in state of 'Historic Version', 'Obsolete', 'Inactive' and 'Terminate'.

      I need the table names / SQL query to update the yellow locks from open to close for Formulation Specification.

       

      Need the table names for Process tab - Bill of Materials and Packaging sections in Formulation Specification.

      Please find the screenshot for reference.