VIEW: MSC.MSC_ST_SUPPLIES#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, TRANSACTION_ID TRANSACTION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID, SOURCE_SCHEDULE_NAME SOURCE_SCHEDULE_NAME, REVISION REVISION, UNIT_NUMBER UNIT_NUMBER, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, OLD_SCHEDULE_DATE OLD_SCHEDULE_DATE, NEW_WIP_START_DATE NEW_WIP_START_DATE, OLD_WIP_START_DATE OLD_WIP_START_DATE, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, LAST_UNIT_START_DATE LAST_UNIT_START_DATE, DISPOSITION_ID DISPOSITION_ID, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE, ORDER_TYPE ORDER_TYPE, SUPPLIER_ID SUPPLIER_ID, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY, OLD_ORDER_QUANTITY OLD_ORDER_QUANTITY, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE, OLD_ORDER_PLACEMENT_DATE OLD_ORDER_PLACEMENT_DATE, RESCHEDULE_DAYS RESCHEDULE_DAYS, RESCHEDULE_FLAG RESCHEDULE_FLAG, SCHEDULE_COMPRESS_DAYS SCHEDULE_COMPRESS_DAYS, NEW_PROCESSING_DAYS NEW_PROCESSING_DAYS, PURCH_LINE_NUM PURCH_LINE_NUM, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE, FIRM_QUANTITY FIRM_QUANTITY, FIRM_DATE FIRM_DATE, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS, IMPLEMENT_DATE IMPLEMENT_DATE, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY, IMPLEMENT_FIRM IMPLEMENT_FIRM, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID, IMPLEMENT_SUPPLIER_ID IMPLEMENT_SUPPLIER_ID, IMPLEMENT_SUPPLIER_SITE_ID IMPLEMENT_SUPPLIER_SITE_ID, IMPLEMENT_AS IMPLEMENT_AS, RELEASE_STATUS RELEASE_STATUS, LOAD_TYPE LOAD_TYPE, PROCESS_SEQ_ID PROCESS_SEQ_ID, SCO_SUPPLY_FLAG SCO_SUPPLY_FLAG, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, SOURCE SOURCE, BY_PRODUCT_USING_ASSY_ID BY_PRODUCT_USING_ASSY_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SR_INSTANCE_ID SOURCE_SR_INSTANCE_ID, SOURCE_SUPPLIER_SITE_ID SOURCE_SUPPLIER_SITE_ID, SOURCE_SUPPLIER_ID SOURCE_SUPPLIER_ID, SHIP_METHOD SHIP_METHOD, WEIGHT_CAPACITY_USED WEIGHT_CAPACITY_USED, VOLUME_CAPACITY_USED VOLUME_CAPACITY_USED, SOURCE_SUPPLY_SCHEDULE_NAME SOURCE_SUPPLY_SCHEDULE_NAME, NEW_SHIP_DATE NEW_SHIP_DATE, NEW_DOCK_DATE NEW_DOCK_DATE, LINE_ID LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID, IMPLEMENT_TASK_ID IMPLEMENT_TASK_ID, IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_SCHEDULE_GROUP_ID, IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_BUILD_SEQUENCE, IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_BOM, IMPLEMENT_ALTERNATE_ROUTING IMPLEMENT_ALTERNATE_ROUTING, IMPLEMENT_UNIT_NUMBER IMPLEMENT_UNIT_NUMBER, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID, RELEASE_ERRORS RELEASE_ERRORS, NUMBER1 NUMBER1, SOURCE_ITEM_ID SOURCE_ITEM_ID, ORDER_NUMBER ORDER_NUMBER, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, SCHEDULE_GROUP_NAME SCHEDULE_GROUP_NAME, BUILD_SEQUENCE BUILD_SEQUENCE, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_ENTITY_NAME WIP_ENTITY_NAME, WO_LATENESS_COST WO_LATENESS_COST, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS, DELIVERY_PRICE DELIVERY_PRICE, LATE_SUPPLY_DATE LATE_SUPPLY_DATE, LATE_SUPPLY_QTY LATE_SUPPLY_QTY, SUBINVENTORY_CODE SUBINVENTORY_CODE, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_INSTANCE_ID SR_INSTANCE_ID, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, PURCH_ORDER_ID PURCH_ORDER_ID, EXPECTED_SCRAP_QTY EXPECTED_SCRAP_QTY, QTY_SCRAPPED QTY_SCRAPPED, QTY_COMPLETED QTY_COMPLETED, LOT_NUMBER LOT_NUMBER, EXPIRATION_DATE EXPIRATION_DATE, WIP_STATUS_CODE WIP_STATUS_CODE, DAILY_RATE DAILY_RATE, LOCATOR_ID LOCATOR_ID, SERIAL_NUMBER SERIAL_NUMBER, REFRESH_ID REFRESH_ID, LOCATOR_NAME LOCATOR_NAME, ONHAND_SOURCE_TYPE ONHAND_SOURCE_TYPE, SR_MTL_SUPPLY_ID SR_MTL_SUPPLY_ID, DEMAND_CLASS DEMAND_CLASS, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, PO_LINE_ID PO_LINE_ID, BILL_SEQUENCE_ID BILL_SEQUENCE_ID, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY, CFM_ROUTING_FLAG CFM_ROUTING_FLAG, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, ITEM_NAME ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE, SUPPLIER_NAME SUPPLIER_NAME, SOURCE_SR_INSTANCE_CODE SOURCE_SR_INSTANCE_CODE, SOURCE_SUPPLIER_SITE_CODE SOURCE_SUPPLIER_SITE_CODE, SOURCE_SUPPLIER_NAME SOURCE_SUPPLIER_NAME, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, SR_INSTANCE_CODE SR_INSTANCE_CODE, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, SCHEDULE_LINE_NUM SCHEDULE_LINE_NUM, ERROR_TEXT ERROR_TEXT, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, BATCH_ID BATCH_ID, BILL_NAME BILL_NAME, ROUTING_NAME ROUTING_NAME, CURR_OP_SEQ_ID CURR_OP_SEQ_ID, LINE_CODE LINE_CODE, EFFECTIVITY_DATE EFFECTIVITY_DATE, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME, SHIP_FROM_SITE_CODE SHIP_FROM_SITE_CODE, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_RELEASE_NUMBER END_ORDER_RELEASE_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, ORDER_RELEASE_NUMBER ORDER_RELEASE_NUMBER, COMMENTS COMMENTS, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME, SHIP_TO_SITE_CODE SHIP_TO_SITE_CODE, PLANNING_PARTNER_SITE_ID PLANNING_PARTNER_SITE_ID, PLANNING_TP_TYPE PLANNING_TP_TYPE, OWNING_PARTNER_SITE_ID OWNING_PARTNER_SITE_ID, OWNING_TP_TYPE OWNING_TP_TYPE, VMI_FLAG VMI_FLAG, NON_NETTABLE_QTY NON_NETTABLE_QTY, ORIGINAL_NEED_BY_DATE ORIGINAL_NEED_BY_DATE, ORIGINAL_QUANTITY ORIGINAL_QUANTITY, PROMISED_DATE PROMISED_DATE, NEED_BY_DATE NEED_BY_DATE, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, END_ORDER_SHIPMENT_NUMBER END_ORDER_SHIPMENT_NUMBER, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, WIP_START_QUANTITY WIP_START_QUANTITY, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, UOM_CODE UOM_CODE, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, QUANTITY_ISSUED QUANTITY_ISSUED, ACK_REFERENCE_NUMBER ACK_REFERENCE_NUMBER, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM, JUMP_OP_SEQ_NUM JUMP_OP_SEQ_NUM, JOB_OP_SEQ_CODE JOB_OP_SEQ_CODE, JUMP_OP_SEQ_CODE JUMP_OP_SEQ_CODE, JUMP_OP_EFFECTIVITY_DATE JUMP_OP_EFFECTIVITY_DATE, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID, SOURCE_VENDOR_ID SOURCE_VENDOR_ID, SOURCE_VENDOR_SITE_ID SOURCE_VENDOR_SITE_ID, SOURCE_TASK_ID SOURCE_TASK_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, SOURCE_FROM_ORGANIZATION_ID SOURCE_FROM_ORGANIZATION_ID, SOURCE_SR_MTL_SUPPLY_ID SOURCE_SR_MTL_SUPPLY_ID, SOURCE_DISPOSITION_ID SOURCE_DISPOSITION_ID, SOURCE_BILL_SEQUENCE_ID SOURCE_BILL_SEQUENCE_ID, SOURCE_ROUTING_SEQUENCE_ID SOURCE_ROUTING_SEQUENCE_ID, SOURCE_SCHEDULE_GROUP_ID SOURCE_SCHEDULE_GROUP_ID, SOURCE_WIP_ENTITY_ID SOURCE_WIP_ENTITY_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, REQUESTED_START_DATE REQUESTED_START_DATE, REQUESTED_COMPLETION_DATE REQUESTED_COMPLETION_DATE, SCHEDULE_PRIORITY SCHEDULE_PRIORITY, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER, ASSET_ITEM_ID ASSET_ITEM_ID, ASSET_ITEM_NAME ASSET_ITEM_NAME, PLANNING_PARTNER_SITE_CODE PLANNING_PARTNER_SITE_CODE, OWNING_PARTNER_SITE_CODE OWNING_PARTNER_SITE_CODE, ACTUAL_START_DATE ACTUAL_START_DATE, SCHEDULE_ORIGINATION_TYPE SCHEDULE_ORIGINATION_TYPE, SR_CUSTOMER_ACCT_ID SR_CUSTOMER_ACCT_ID, ITEM_TYPE_ID ITEM_TYPE_ID, ITEM_TYPE_VALUE ITEM_TYPE_VALUE, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, RO_STATUS_CODE RO_STATUS_CODE, SR_REPAIR_GROUP_ID SR_REPAIR_GROUP_ID, SR_REPAIR_TYPE_ID SR_REPAIR_TYPE_ID, RO_CREATION_DATE RO_CREATION_DATE, REPAIR_LEAD_TIME REPAIR_LEAD_TIME, REQ_LINE_ID REQ_LINE_ID, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID, CONDITION_TYPE CONDITION_TYPE, REPAIR_NUMBER REPAIR_NUMBER, DESCRIPTION DESCRIPTION, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE, PRODUCES_TO_STOCK PRODUCES_TO_STOCK, ACTIVITY_TYPE ACTIVITY_TYPE, CLASS_CODE CLASS_CODE, SHUTDOWN_TYPE SHUTDOWN_TYPE, TO_BE_EXPLODED TO_BE_EXPLODED, OBJECT_TYPE OBJECT_TYPE, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE, ACTIVITY_ITEM_ID ACTIVITY_ITEM_ID, VISIT_ID VISIT_ID, ASSET_NUMBER ASSET_NUMBER, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE, OPERATING_FLEET OPERATING_FLEET, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT, PRODUCT_CLASSIFICATION PRODUCT_CLASSIFICATION, COLL_ORDER_TYPE COLL_ORDER_TYPE from "MSC"."MSC_ST_SUPPLIES"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, TRANSACTION_ID TRANSACTION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID
, SOURCE_SCHEDULE_NAME SOURCE_SCHEDULE_NAME
, REVISION REVISION
, UNIT_NUMBER UNIT_NUMBER
, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, OLD_SCHEDULE_DATE OLD_SCHEDULE_DATE
, NEW_WIP_START_DATE NEW_WIP_START_DATE
, OLD_WIP_START_DATE OLD_WIP_START_DATE
, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE LAST_UNIT_START_DATE
, DISPOSITION_ID DISPOSITION_ID
, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE
, ORDER_TYPE ORDER_TYPE
, SUPPLIER_ID SUPPLIER_ID
, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY
, OLD_ORDER_QUANTITY OLD_ORDER_QUANTITY
, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE
, OLD_ORDER_PLACEMENT_DATE OLD_ORDER_PLACEMENT_DATE
, RESCHEDULE_DAYS RESCHEDULE_DAYS
, RESCHEDULE_FLAG RESCHEDULE_FLAG
, SCHEDULE_COMPRESS_DAYS SCHEDULE_COMPRESS_DAYS
, NEW_PROCESSING_DAYS NEW_PROCESSING_DAYS
, PURCH_LINE_NUM PURCH_LINE_NUM
, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS
, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY
, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE
, FIRM_QUANTITY FIRM_QUANTITY
, FIRM_DATE FIRM_DATE
, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS
, IMPLEMENT_DATE IMPLEMENT_DATE
, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY
, IMPLEMENT_FIRM IMPLEMENT_FIRM
, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME
, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE
, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE
, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE
, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID
, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID
, IMPLEMENT_SUPPLIER_ID IMPLEMENT_SUPPLIER_ID
, IMPLEMENT_SUPPLIER_SITE_ID IMPLEMENT_SUPPLIER_SITE_ID
, IMPLEMENT_AS IMPLEMENT_AS
, RELEASE_STATUS RELEASE_STATUS
, LOAD_TYPE LOAD_TYPE
, PROCESS_SEQ_ID PROCESS_SEQ_ID
, SCO_SUPPLY_FLAG SCO_SUPPLY_FLAG
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, SOURCE SOURCE
, BY_PRODUCT_USING_ASSY_ID BY_PRODUCT_USING_ASSY_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_SR_INSTANCE_ID SOURCE_SR_INSTANCE_ID
, SOURCE_SUPPLIER_SITE_ID SOURCE_SUPPLIER_SITE_ID
, SOURCE_SUPPLIER_ID SOURCE_SUPPLIER_ID
, SHIP_METHOD SHIP_METHOD
, WEIGHT_CAPACITY_USED WEIGHT_CAPACITY_USED
, VOLUME_CAPACITY_USED VOLUME_CAPACITY_USED
, SOURCE_SUPPLY_SCHEDULE_NAME SOURCE_SUPPLY_SCHEDULE_NAME
, NEW_SHIP_DATE NEW_SHIP_DATE
, NEW_DOCK_DATE NEW_DOCK_DATE
, LINE_ID LINE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID
, IMPLEMENT_TASK_ID IMPLEMENT_TASK_ID
, IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_SCHEDULE_GROUP_ID
, IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_BUILD_SEQUENCE
, IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_BOM
, IMPLEMENT_ALTERNATE_ROUTING IMPLEMENT_ALTERNATE_ROUTING
, IMPLEMENT_UNIT_NUMBER IMPLEMENT_UNIT_NUMBER
, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID
, RELEASE_ERRORS RELEASE_ERRORS
, NUMBER1 NUMBER1
, SOURCE_ITEM_ID SOURCE_ITEM_ID
, ORDER_NUMBER ORDER_NUMBER
, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID
, SCHEDULE_GROUP_NAME SCHEDULE_GROUP_NAME
, BUILD_SEQUENCE BUILD_SEQUENCE
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, WO_LATENESS_COST WO_LATENESS_COST
, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS
, DELIVERY_PRICE DELIVERY_PRICE
, LATE_SUPPLY_DATE LATE_SUPPLY_DATE
, LATE_SUPPLY_QTY LATE_SUPPLY_QTY
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID SR_INSTANCE_ID
, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, PURCH_ORDER_ID PURCH_ORDER_ID
, EXPECTED_SCRAP_QTY EXPECTED_SCRAP_QTY
, QTY_SCRAPPED QTY_SCRAPPED
, QTY_COMPLETED QTY_COMPLETED
, LOT_NUMBER LOT_NUMBER
, EXPIRATION_DATE EXPIRATION_DATE
, WIP_STATUS_CODE WIP_STATUS_CODE
, DAILY_RATE DAILY_RATE
, LOCATOR_ID LOCATOR_ID
, SERIAL_NUMBER SERIAL_NUMBER
, REFRESH_ID REFRESH_ID
, LOCATOR_NAME LOCATOR_NAME
, ONHAND_SOURCE_TYPE ONHAND_SOURCE_TYPE
, SR_MTL_SUPPLY_ID SR_MTL_SUPPLY_ID
, DEMAND_CLASS DEMAND_CLASS
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, PO_LINE_ID PO_LINE_ID
, BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY
, CFM_ROUTING_FLAG CFM_ROUTING_FLAG
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, ITEM_NAME ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, SUPPLIER_NAME SUPPLIER_NAME
, SOURCE_SR_INSTANCE_CODE SOURCE_SR_INSTANCE_CODE
, SOURCE_SUPPLIER_SITE_CODE SOURCE_SUPPLIER_SITE_CODE
, SOURCE_SUPPLIER_NAME SOURCE_SUPPLIER_NAME
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, SCHEDULE_LINE_NUM SCHEDULE_LINE_NUM
, ERROR_TEXT ERROR_TEXT
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, BATCH_ID BATCH_ID
, BILL_NAME BILL_NAME
, ROUTING_NAME ROUTING_NAME
, CURR_OP_SEQ_ID CURR_OP_SEQ_ID
, LINE_CODE LINE_CODE
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME
, SHIP_FROM_SITE_CODE SHIP_FROM_SITE_CODE
, END_ORDER_NUMBER END_ORDER_NUMBER
, END_ORDER_RELEASE_NUMBER END_ORDER_RELEASE_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, ORDER_RELEASE_NUMBER ORDER_RELEASE_NUMBER
, COMMENTS COMMENTS
, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME
, SHIP_TO_SITE_CODE SHIP_TO_SITE_CODE
, PLANNING_PARTNER_SITE_ID PLANNING_PARTNER_SITE_ID
, PLANNING_TP_TYPE PLANNING_TP_TYPE
, OWNING_PARTNER_SITE_ID OWNING_PARTNER_SITE_ID
, OWNING_TP_TYPE OWNING_TP_TYPE
, VMI_FLAG VMI_FLAG
, NON_NETTABLE_QTY NON_NETTABLE_QTY
, ORIGINAL_NEED_BY_DATE ORIGINAL_NEED_BY_DATE
, ORIGINAL_QUANTITY ORIGINAL_QUANTITY
, PROMISED_DATE PROMISED_DATE
, NEED_BY_DATE NEED_BY_DATE
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, END_ORDER_SHIPMENT_NUMBER END_ORDER_SHIPMENT_NUMBER
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, WIP_START_QUANTITY WIP_START_QUANTITY
, ORDER_LINE_NUMBER ORDER_LINE_NUMBER
, UOM_CODE UOM_CODE
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, QUANTITY_ISSUED QUANTITY_ISSUED
, ACK_REFERENCE_NUMBER ACK_REFERENCE_NUMBER
, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM
, JUMP_OP_SEQ_NUM JUMP_OP_SEQ_NUM
, JOB_OP_SEQ_CODE JOB_OP_SEQ_CODE
, JUMP_OP_SEQ_CODE JUMP_OP_SEQ_CODE
, JUMP_OP_EFFECTIVITY_DATE JUMP_OP_EFFECTIVITY_DATE
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID
, SOURCE_VENDOR_ID SOURCE_VENDOR_ID
, SOURCE_VENDOR_SITE_ID SOURCE_VENDOR_SITE_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, SOURCE_FROM_ORGANIZATION_ID SOURCE_FROM_ORGANIZATION_ID
, SOURCE_SR_MTL_SUPPLY_ID SOURCE_SR_MTL_SUPPLY_ID
, SOURCE_DISPOSITION_ID SOURCE_DISPOSITION_ID
, SOURCE_BILL_SEQUENCE_ID SOURCE_BILL_SEQUENCE_ID
, SOURCE_ROUTING_SEQUENCE_ID SOURCE_ROUTING_SEQUENCE_ID
, SOURCE_SCHEDULE_GROUP_ID SOURCE_SCHEDULE_GROUP_ID
, SOURCE_WIP_ENTITY_ID SOURCE_WIP_ENTITY_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, REQUESTED_START_DATE REQUESTED_START_DATE
, REQUESTED_COMPLETION_DATE REQUESTED_COMPLETION_DATE
, SCHEDULE_PRIORITY SCHEDULE_PRIORITY
, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER
, ASSET_ITEM_ID ASSET_ITEM_ID
, ASSET_ITEM_NAME ASSET_ITEM_NAME
, PLANNING_PARTNER_SITE_CODE PLANNING_PARTNER_SITE_CODE
, OWNING_PARTNER_SITE_CODE OWNING_PARTNER_SITE_CODE
, ACTUAL_START_DATE ACTUAL_START_DATE
, SCHEDULE_ORIGINATION_TYPE SCHEDULE_ORIGINATION_TYPE
, SR_CUSTOMER_ACCT_ID SR_CUSTOMER_ACCT_ID
, ITEM_TYPE_ID ITEM_TYPE_ID
, ITEM_TYPE_VALUE ITEM_TYPE_VALUE
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, RO_STATUS_CODE RO_STATUS_CODE
, SR_REPAIR_GROUP_ID SR_REPAIR_GROUP_ID
, SR_REPAIR_TYPE_ID SR_REPAIR_TYPE_ID
, RO_CREATION_DATE RO_CREATION_DATE
, REPAIR_LEAD_TIME REPAIR_LEAD_TIME
, REQ_LINE_ID REQ_LINE_ID
, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID
, CONDITION_TYPE CONDITION_TYPE
, REPAIR_NUMBER REPAIR_NUMBER
, DESCRIPTION DESCRIPTION
, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE
, PRODUCES_TO_STOCK PRODUCES_TO_STOCK
, ACTIVITY_TYPE ACTIVITY_TYPE
, CLASS_CODE CLASS_CODE
, SHUTDOWN_TYPE SHUTDOWN_TYPE
, TO_BE_EXPLODED TO_BE_EXPLODED
, OBJECT_TYPE OBJECT_TYPE
, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE
, ACTIVITY_ITEM_ID ACTIVITY_ITEM_ID
, VISIT_ID VISIT_ID
, ASSET_NUMBER ASSET_NUMBER
, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID
, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE
, OPERATING_FLEET OPERATING_FLEET
, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT
, PRODUCT_CLASSIFICATION PRODUCT_CLASSIFICATION
, COLL_ORDER_TYPE COLL_ORDER_TYPE
FROM "MSC"."MSC_ST_SUPPLIES"