Manufacturing - JDE1 (MOSC)

MOSC Banner

Table details

edited Jun 1, 2017 8:41AM in Manufacturing - JDE1 (MOSC) 2 commentsAnswered

Hi All,

I have to build and perform sql (in order to change large data) for below details for EAM.

But I am not sure what are the all tables I have to consider. Can you have look on below details and suggest me if anything
wrong or I missed, please.

  1. Spare Parts: All item numbers in BP140 which are at status P:

     Set to status O. - F4102

2. Assets (Systems, Equipment Instruments) at status IN (in service):

     Set to status to DC. - F1201

3. Preventative Maintenance Routines:

     Deactivate all Model WOs. - No idea.

4. Planned and Unplanned Maintenance Work Orders - All WM and WS Work Order at status M to ME:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center