1 Reply Latest reply on Jul 11, 2011 11:46 PM by 857543

    Match WIP_JOB_STATUS to system_status type

    857543
      Hi

      I have a req where I am supposed to add a new status type to jobs

      eg new status name eg disconnect ( system_status complete).

      I know the first part's easy I just add the new status type to the lookup WIP_JOB_STATUS

      Thats easy to do.Whats also mentioned is the system_type of the job_status.


      There is another table column apps.eam_work_order_details.user_defined_status_id.

      Is there a way to connect a status type from WIP_JOB_STATUS to the system status.

      I think they are both from the same lookup but was wondering if there is a table that connects the two.
      so a certain status type (eg disconnect) can be set only for a certain system status (complete)

      Thanks
      D