WIP discrete job table in Oracle Fusion

Hi friends, we are going to discuss about wip discrete job tables in oracle fusion. We will share some of the most important wip discrete job tables which helps to store the wip discrete job information’s in oracle fusion. In Oracle fusion, wip discrete job tables are totally changed as compared to oracle apps r12 wip discrete job tables. As an oracle fusion scm consultant, we should have the complete knowledge of wip discrete job tables and the technical flow of these tables in oracle fusion. We will also share the complete sql query to extract the wip discrete job information’s in oracle fusion. Using this WIP discrete job tables we can write the sql query to extract the wip job’s data and develop the custom wip discrete job BIP reports in oracle fusion. Please find below the complete wip discrete job tables in oracle fusion.

WIP discrete job table in Oracle Fusion

4 Most Important Discrete job tables in oracle fusion

1.      WIS_WORK_DEFINITIONS_V

2.       WIS_WD_OPERATIONS_V

3.       WIS_WD_OPERATION_RESOURCES_V

4.       WIS_WD_OPERATION_MATERIALS_V

SQL Query to Extract the WIP discrete job informations in Oracle Fusion

Here below is the detail sql query which helps to extract the complete WIP discrete job related informations in oracle fusion. We can refer these sql queries to develop the custom BIP reports in oracle fusion.

SQL Query 1:- 

SELECT  WWO.WORK_DEFINITION_ID,

        WWO.OPERATION_TYPE,

        WWO.WD_OPERATION_ID,

        WWO.OPERATION_SEQ_NUMBER,

        WWO.OPERATION_NAME,

        WWO.OPERATION_DESCRIPTION,

        WWO.WORK_CENTER_CODE,

        WWO.WORK_CENTER_NAME,

        WWO.WORK_CENTER_DESCRIPTION,

        WWO.WORK_CENTER_ID

FROM WIS_WD_OPERATIONS_V WWO

WHERE WWO.EFFECTIVE_TO_DATE IS NULL

GROUP BY WWO.WORK_DEFINITION_ID,

        WWO.OPERATION_TYPE,

        WWO.WD_OPERATION_ID,

        WWO.OPERATION_SEQ_NUMBER,

        WWO.OPERATION_NAME,

        WWO.OPERATION_DESCRIPTION,

        WWO.WORK_CENTER_CODE,

        WWO.WORK_CENTER_NAME,

        WWO.WORK_CENTER_DESCRIPTION,

        WWO.WORK_CENTER_ID

SQL query 2:-

SELECT WOR.RESOURCE_SEQ_NUMBER,

        WOR.RESOURCE_TYPE,

        WOR.RESOURCE_CODE,

        WOR.RESOURCE_NAME,

        WOR.WORK_CENTER_ID,

        WOR.WD_OPERATION_ID

FROM WIS_WD_OPERATION_RESOURCES_V WOR

GROUP BY WOR.RESOURCE_SEQ_NUMBER,

        WOR.RESOURCE_TYPE,

        WOR.RESOURCE_CODE,

        WOR.RESOURCE_NAME,

        WOR.WORK_CENTER_ID,

        WOR.WD_OPERATION_ID

SQL Query 3:- 

SELECT (SELECT ITEM_NUMBER FROM EGP_SYSTEM_ITEMS_B WHERE ORGANIZATION_ID = WOM.ORGANIZATION_ID AND INVENTORY_ITEM_ID = WOM.INVENTORY_ITEM_ID) COMP_ITEM_CODE,

        WOM.UOM_CODE COMP_UOM_CODE,

        WOM.YIELD_FACTOR,

        WOM.SUPPLY_SUBINVENTORY_NAME,

        WOM.COMPONENT_QUANTITY,

        WOM.WORK_DEFINITION_ID,

        WOM.WD_OPERATION_ID

FROM WIS_WD_OPERATION_MATERIALS_V WOM

WHERE WOM.DISABLE_DATE IS NULL

GROUP BY WOM.UOM_CODE,

        WOM.YIELD_FACTOR,

        WOM.SUPPLY_SUBINVENTORY_NAME,

        WOM.COMPONENT_QUANTITY,

        WOM.WORK_DEFINITION_ID,

        WOM.WD_OPERATION_ID,

        WOM.ORGANIZATION_ID,

        WOM.INVENTORY_ITEM_ID

WIP discrete job table in Oracle Fusion