Work Order status table in oracle apps
In this post , We will be discuss about the Work Order status table in oracle apps. When we do create the wip work orders jobs in oracle application , then these information do store in the wip_discrete_jobs table. In this table , We do also get the Work Order status information but in the wip_discrete_jobs table system only store the Work order status id in the column 'Status Type'. To know the actual meaning of the work order status , we need to join the wip_discrete_jobs tablw with the lookup table fnd_lookup_values. Oracle application do stores the work order status information in the lookups with Lookup type 'WIP_JOB_STATUS'. Here below I will share the detail sql query to extract the Work Order status table in oracle apps.
Important Tables to get Work Order status table in oracle apps
1. apps.wip_discrete_jobs
2.fnd_lookup_values
Detail SQL query to get the Work Order status table in oracle apps
select A1.WIP_ENTITY_ID,A1.DESCRIPTION,A1.START_QUANTITY,STATUS_TYPE,A2.MEANING from apps.wip_discrete_jobs A1, apps.fnd_lookup_values A2
WHERE A2.lookup_type LIKE '%WIP_JOB_STATUS%'
AND TO_CHAR(A1.STATUS_TYPE)=A2.lookup_code
AND A2.language='US'
1 comments:
We should always be alert about our timing because if we lost our time once without doing any work then it will become very hard for us to get back the time. And if you are very busy with your work then you don't need to borrow any assistant to say your schedule because now you can use weekly timesheet which is totally and orapex is calling it itimeplus best time tracking software.
Post a Comment