ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 2F79748379844009E0636ADA860A849A XXFT Assembly(Org dependent) Y SELECT segment1 value, null description FROM mtl_system_items msi, bom_bill_of_materials bom WHERE bom.assembly_item_id = msi.inventory_item_id AND msi.organization_id IN (SELECT organization_id FROM org_organization_definitions WHERE organization_code = :$flex$.organization) US 2BD70A764DCC1D05E0636ADA860A2B9D XXFT Organization LOV Y select organization_code value,organization_name description from ORG_ACCESS_V where responsibility_id = fnd_global.RESP_ID US 2F78CE1A8E45064CE0636ADA860AB3FF 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 Y U A xxft_load_wo_stg.insert_wo_data US Ferrotec Work Order Creation Upload Process Upload 1=1 2=2 1 -999999990 &upload_records <parameter_value> Reporting dual US Reporting SQL Reporting SQL 2 10 1=1 MSIA.organization_id IN (SELECT organization_id FROM org_organization_definitions WHERE organization_code=:organization_code) LOV XXFT Organization LOV 2BD70A764DCC1D05E0636ADA860A2B9D Y select organization_code value,organization_name description from ORG_ACCESS_V where responsibility_id = fnd_global.RESP_ID Y US Organization 3 2=2 msic.organization_id IN (SELECT organization_id FROM org_organization_definitions WHERE organization_code=:organization_code) US Organization 4 20 1=1 MSIA.SEGMENT1 = :segment1 LOV XXFT Assembly(Org dependent) 2F79748379844009E0636ADA860A849A Y SELECT segment1 value, null description FROM mtl_system_items msi, bom_bill_of_materials bom WHERE bom.assembly_item_id = msi.inventory_item_id AND msi.organization_id IN (SELECT organization_id FROM org_organization_definitions WHERE organization_code = :$flex$.organization) Y US Assembly :$flex$.organization Organization Assembly 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 BATCH_ID Char varchar2 xxen_util.sequence_nextval(' XXFT_AUTO_WO_S') Y 5 BATCH_NAME Char varchar2 Y 6 ORGANIZATION_CODE Char varchar2 Y 7 TOP_ASSEMBLY_ITEM Char varchar2 Y 8 ASSEMBLY_ITEM Char varchar2 Y 9 ASSEMBLY_ITEM_ID Number number 10 WO_ASSEM_PREFIX Char varchar2 Y 11 ASSEMBLY_DESC Char varchar2 Y 12 WO_QUANTITY Number number Y 13 WO_START_DATE Date date Y 14 ASSEM_PL_CATEGORY Char varchar2 Y 15 ASSE_ITEM_CATEGORY_ID Number number 16 STD_DISCRETE_CLASS Char varchar2 Y 17 ORGANIZATION_ID Number number