Ferrotec Work Order Creation Upload Process

SELECT  xxen_upload.action_meaning(xxen_upload.action_create) action_,
               xxen_upload.status_meaning(xxen_upload.status_new) status_,
               null message_,
               null Batch_id,
              (SELECT 'AUTOWO-' || TO_CHAR(SYSDATE, 'MMDDRRHHMMSS') FROM DUAL) batch_name,
              OOD.ORGANIZATION_CODE,
             MSIA.SEGMENT1    TOP_ASSEMBLY_ITEM,
             MSIA.SEGMENT1    ASSEMBLY_ITEM,
             MSIA.INVENTORY_ITEM_ID   ASSEMBLY_ITEM_ID,
             DECODE (MSIA.attribute9,'', 'Please define wo prefix in item master',MSIA.attribute9 || 'T')  WO_ASSEM_PREFIX,
             MSIA.DESCRIPTION   ASSEMBLY_DESC,
             1    WO_QUANTITY,
             SYSDATE    WO_START_DATE,
            MICA.CATEGORY_CONCAT_SEGS   ASSEM_PL_CATEGORY,
            MICA.CATEGORY_ID    ASSE_ITEM_CATEGORY_ID,
            WDC.STD_DISCRETE_CLASS,
            MSIA.organization_id organization_id 
 FROM ORG_ORGANIZATION_DEFINITIONS  OOD,
            BOM_BILL_OF_MATERIALS         BOMA,
            WIP_DEF_CAT_ACC_CLASSES       WDC,
            MTL_ITEM_CATEGORIES_V         MICA,
            MTL_SYSTEM_ITEMS              MSIA
WHERE OOD.ORGANIZATION_ID = MSIA.ORGANIZATION_ID
AND BOMA.ASSEMBLY_ITEM_ID = MSIA.INVENTORY_ITEM_ID
AND MSIA.INVENTORY_ITEM_ID = MICA.INVENTORY_ITEM_ID
AND MSIA.ORGANIZATION_ID = MICA.ORGANIZATION_ID
AND MICA.CATEGORY_SET_NAME = 'Product Line'
AND MSIA.PLANNING_MAKE_BUY_CODE = 1
AND WDC.CATEGORY_ID = MICA.CATEGORY_ID(+)
AND WDC.ORGANIZATION_ID = MICA.ORGANIZATION_ID(+)
AND 1 = 1
UNION
SELECT   xxen_upload.action_meaning(xxen_upload.action_create) action_,
               xxen_upload.status_meaning(xxen_upload.status_new) status_,
               null message_,
               null Batch_id,
              (SELECT 'AUTOWO-' || TO_CHAR(SYSDATE, 'MMDDRRHHMMSS') FROM DUAL) batch_name,
              OOD.ORGANIZATION_CODE,
              MSIA.SEGMENT1  TOP_ASSEMBLY_ITEM,
              MSIC.SEGMENT1  ASSEMBLY_ITEM,
              MSIC.INVENTORY_ITEM_ID  ASSMBLY_ITEM_ID,
              DECODE (MSIC.attribute9, '', 'Please define wo prefix in item master',MSIA.attribute9 || MSIC.attribute9) WO_ASSEM_PREFIX,
              MSIC.DESCRIPTION   ASSEMBLY_DESC,
              BOMC.COMPONENT_QUANTITY   WO_QUANTITY,
              SYSDATE   WO_START_DATE,
              MICC.CATEGORY_CONCAT_SEGS   ASSEM_PL_CATEGORY,
              MICC.CATEGORY_ID   ASSE_ITEM_CATEGORY_ID,
              WDC.STD_DISCRETE_CLASS,
              MSIA.organization_id organization_id 
FROM ORG_ORGANIZATION_DEFINITIONS  OOD,
           BOM_INVENTORY_COMPONENTS_V    BOMC,
           BOM_BILL_OF_MATERIALS         BOMA,
           WIP_DEF_CAT_ACC_CLASSES       WDC,
           MTL_ITEM_CATEGORIES_V         MICC,
           MTL_SYSTEM_ITEMS              MSIC,
           MTL_SYSTEM_ITEMS              MSIA
WHERE BOMC.BILL_SEQUENCE_ID = BOMA.BILL_SEQUENCE_ID
AND BOMC.COMPONENT_ITEM_ID = MSIC.INVENTORY_ITEM_ID
AND OOD.ORGANIZATION_ID = MSIC.ORGANIZATION_ID
AND MSIC.organization_id = 181
AND BOMA.ASSEMBLY_ITEM_ID = MSIA.INVENTORY_ITEM_ID
AND MSIC.INVENTORY_ITEM_ID = MICC.INVENTORY_ITEM_ID
AND MSIC.ORGANIZATION_ID = MICC.ORGANIZATION_ID
AND MICC.CATEGORY_SET_NAME = 'Product Line'
AND MSIC.PLANNING_MAKE_BUY_CODE = 1
AND WDC.CATEGORY_ID = MICC.CATEGORY_ID(+)
AND WDC.ORGANIZATION_ID = MICC.ORGANIZATION_ID(+)
AND BOMC.DISABLE_DATE IS NULL
AND BOMC.COMPONENT_QUANTITY > 0
AND 1 = 1
and 2=2
ORDER BY 1 ,5 desc