What is the Join Condition Between GMO_DISPENSE_CONFIG And GMO_INSTR_SET_DEFN_T and GMO_INSTR_DEFN_T Tables?
(Doc ID 2216138.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle MES for Process Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
Unable to find the Join condition Between GMO_DISPENSE_CONFIG and (GMO_INSTR_SET_DEFN_T,GMO_INSTR_DEFN_T) tables.
We need a data extract listing the Items that have Dispensing Rules setup. Also, their dispensing setup details and instructions. Listed below are the required fields for the extract in single query:
Security Tag Required
No of Signature
We are able to idenify the columns through OAF pages, but unable to join the condtion among those queries. Please find the Queries attached.
And we are unable to find SOP columns query informaion.
And the path of the page is /oracle/apps/gmo/dispense/setup/webui/DispenseSetupCreatePG .
Please find the Responsibility Name :: MES for Process Manufacturing Administrator.
Please find the screen shots attached.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document