Query to get Work Order details in oracle Fusion

Query to get Work Order details in oracle Fusion

Hi friends , we are going to discuss about the Query to get Work Order details in oracle Fusion. We will share the detail sql query which helps to extract the complete work order details. In this post , we will also try to share work order tables too which helps to store the important work order information's in oracle fusion. Using this work order query we can develop the custom BIP report which helps to extract the complete work order information's. This is one of the important sql query in oracle fusion. In Oracle Fusion WIP , this is one of the most important work order query in oracle fusion. Please find below the complete details about Query to get Work Order details in oracle Fusion.

Query to get Work Order details in oracle Fusion

4 Important Tables to store the work order details in oracle fusion

Here below is the list of oracle fusion work order tables which helps to store the complete information's about work order and its resources in oracle fusion application.

1.fnd_lookup_values

2.wie_wo_statuses_tl

3.fnd_lookup_values 

4.wie_work_orders_b

Detail SQL Query to extract the Work Order details in oracle Fusion

Here below is the detail sql query which helps to extract the complete information's about the work order information's in oracle fusion. This is very important sql query which will help you to give the complete details about work order and its resources in oracle fusion.

SELECT 

wwob.work_order_number " Work Order Number",

planned_start_date " Work Order Plan Start Date",

planned_completion_date " Plan Completion Date",

actual_start_date " Actual Strt Date",

actual_completion_date " Actual Completion Date",

stat_tl.wo_status_name "WO Status",

nvl(to_char(wwob.actual_completion_date, ‘MM/DD/YYYY’),

to_char(wwob.planned_completion_date, ‘MM/DD/YYYY’)) wo_completion_date,

flv.meaning work_order_type " Work Order Type",

flv_sub.meaning work_order_sub_type " Work Order Sub Type"

FROM 

wie_wo_statuses_tl stat_tl,

fnd_lookup_values flv,

wie_work_orders_b wwob,

fnd_lookup_values flv_sub

where 1=1

AND wwob.work_order_number = :P_WORK_ORDER

and stat_tl.language = USERENV(‘LANG’)

AND flv.lookup_code = wwob.WORK_ORDER_TYPE

AND flv.lookup_type = 'ORA_WIE_WO_TYPE'

AND flv_sub.lookup_type = 'ORA_WIE_WO_SUB_TYPE'

AND flv_sub.lookup_code = wwob.work_order_sub_type

AND wwob.WORK_ORDER_STATUS_ID = stat_tl.WO_STATUS_ID

ORDER BY 1

Query to get Work Order details in oracle Fusion

Query to get Work Order details in oracle Fusion