VIEW: MSC.MSC_STORE_SUPPLIES#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, TRANSACTION_ID TRANSACTION_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID, 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, SUPPLIER_SITE_ID SUPPLIER_SITE_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_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID, IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_SR_INSTANCE_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, 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, NEW_SHIP_DATE NEW_SHIP_DATE, NEW_DOCK_DATE NEW_DOCK_DATE, OLD_DOCK_DATE OLD_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, BUILD_SEQUENCE BUILD_SEQUENCE, WIP_ENTITY_NAME WIP_ENTITY_NAME, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS, DELIVERY_PRICE DELIVERY_PRICE, LATE_SUPPLY_DATE LATE_SUPPLY_DATE, LATE_SUPPLY_QTY LATE_SUPPLY_QTY, LOT_NUMBER LOT_NUMBER, SUBINVENTORY_CODE SUBINVENTORY_CODE, QTY_SCRAPPED QTY_SCRAPPED, EXPECTED_SCRAP_QTY EXPECTED_SCRAP_QTY, QTY_COMPLETED QTY_COMPLETED, DAILY_RATE DAILY_RATE, SCHEDULE_GROUP_NAME SCHEDULE_GROUP_NAME, UPDATED UPDATED, SUBST_ITEM_FLAG SUBST_ITEM_FLAG, STATUS STATUS, APPLIED APPLIED, EXPIRATION_QUANTITY EXPIRATION_QUANTITY, EXPIRATION_DATE EXPIRATION_DATE, NON_NETTABLE_QTY NON_NETTABLE_QTY, IMPLEMENT_WIP_START_DATE IMPLEMENT_WIP_START_DATE, REFRESH_NUMBER REFRESH_NUMBER, 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, IMPLEMENT_DAILY_RATE IMPLEMENT_DAILY_RATE, NEED_BY_DATE NEED_BY_DATE, SOURCE_SUPPLY_ID SOURCE_SUPPLY_ID, SR_MTL_SUPPLY_ID SR_MTL_SUPPLY_ID, WIP_STATUS_CODE WIP_STATUS_CODE, DEMAND_CLASS DEMAND_CLASS, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, PO_LINE_ID PO_LINE_ID, LOAD_FACTOR_RATE LOAD_FACTOR_RATE, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, BILL_SEQUENCE_ID BILL_SEQUENCE_ID, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY, CFM_ROUTING_FLAG CFM_ROUTING_FLAG, CUSTOMER_ID CUSTOMER_ID, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, OLD_NEED_BY_DATE OLD_NEED_BY_DATE, OLD_DAILY_RATE OLD_DAILY_RATE, OLD_FIRST_UNIT_START_DATE OLD_FIRST_UNIT_START_DATE, OLD_LAST_UNIT_COMPLETION_DATE OLD_LAST_UNIT_COMPLETION_DATE, OLD_NEW_SCHEDULE_DATE OLD_NEW_SCHEDULE_DATE, OLD_QTY_COMPLETED OLD_QTY_COMPLETED, OLD_NEW_ORDER_QUANTITY OLD_NEW_ORDER_QUANTITY, OLD_FIRM_QUANTITY OLD_FIRM_QUANTITY, OLD_FIRM_DATE OLD_FIRM_DATE, 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, EARLIEST_START_DATE EARLIEST_START_DATE, EARLIEST_COMPLETION_DATE EARLIEST_COMPLETION_DATE, MIN_START_DATE MIN_START_DATE, SCHEDULED_DEMAND_ID SCHEDULED_DEMAND_ID, EXPLOSION_DATE EXPLOSION_DATE, SCO_SUPPLY_DATE SCO_SUPPLY_DATE, RECORD_SOURCE RECORD_SOURCE, SUPPLY_IS_SHARED SUPPLY_IS_SHARED, ULPSD ULPSD, ULPCD ULPCD, UEPSD UEPSD, UEPCD UEPCD, EACD EACD, ORIGINAL_NEED_BY_DATE ORIGINAL_NEED_BY_DATE, ORIGINAL_QUANTITY ORIGINAL_QUANTITY, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, PROMISED_DATE PROMISED_DATE, WIP_START_QUANTITY WIP_START_QUANTITY, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, QUANTITY_ISSUED QUANTITY_ISSUED, UNBUCKETED_DEMAND_DATE UNBUCKETED_DEMAND_DATE, SHIPMENT_ID SHIPMENT_ID, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM, JUMP_OP_SEQ_NUM JUMP_OP_SEQ_NUM, SHIP_CALENDAR SHIP_CALENDAR, RECEIVING_CALENDAR RECEIVING_CALENDAR, INTRANSIT_CALENDAR INTRANSIT_CALENDAR, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, OLD_SHIP_DATE OLD_SHIP_DATE, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE, ORIG_SHIP_METHOD ORIG_SHIP_METHOD, ORIG_INTRANSIT_LEAD_TIME ORIG_INTRANSIT_LEAD_TIME, PARENT_ID PARENT_ID, DAYS_LATE DAYS_LATE, SCHEDULE_PRIORITY SCHEDULE_PRIORITY, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, WSM_FAULTY_NETWORK WSM_FAULTY_NETWORK, IMPLEMENT_DEST_ORG_ID IMPLEMENT_DEST_ORG_ID, IMPLEMENT_DEST_INST_ID IMPLEMENT_DEST_INST_ID, REQUESTED_START_DATE REQUESTED_START_DATE, REQUESTED_COMPLETION_DATE REQUESTED_COMPLETION_DATE, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER, ASSET_ITEM_ID ASSET_ITEM_ID, TOP_TRANSACTION_ID TOP_TRANSACTION_ID, UNBUCKETED_NEW_SCHED_DATE UNBUCKETED_NEW_SCHED_DATE, IMPLEMENT_SHIP_METHOD IMPLEMENT_SHIP_METHOD, ACTUAL_START_DATE ACTUAL_START_DATE from "MSC"."MSC_STORE_SUPPLIES"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, TRANSACTION_ID TRANSACTION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID
, 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
, SUPPLIER_SITE_ID SUPPLIER_SITE_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_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID
, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE
, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID
, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID
, IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_SR_INSTANCE_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
, 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
, NEW_SHIP_DATE NEW_SHIP_DATE
, NEW_DOCK_DATE NEW_DOCK_DATE
, OLD_DOCK_DATE OLD_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
, BUILD_SEQUENCE BUILD_SEQUENCE
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS
, DELIVERY_PRICE DELIVERY_PRICE
, LATE_SUPPLY_DATE LATE_SUPPLY_DATE
, LATE_SUPPLY_QTY LATE_SUPPLY_QTY
, LOT_NUMBER LOT_NUMBER
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, QTY_SCRAPPED QTY_SCRAPPED
, EXPECTED_SCRAP_QTY EXPECTED_SCRAP_QTY
, QTY_COMPLETED QTY_COMPLETED
, DAILY_RATE DAILY_RATE
, SCHEDULE_GROUP_NAME SCHEDULE_GROUP_NAME
, UPDATED UPDATED
, SUBST_ITEM_FLAG SUBST_ITEM_FLAG
, STATUS STATUS
, APPLIED APPLIED
, EXPIRATION_QUANTITY EXPIRATION_QUANTITY
, EXPIRATION_DATE EXPIRATION_DATE
, NON_NETTABLE_QTY NON_NETTABLE_QTY
, IMPLEMENT_WIP_START_DATE IMPLEMENT_WIP_START_DATE
, REFRESH_NUMBER REFRESH_NUMBER
, 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
, IMPLEMENT_DAILY_RATE IMPLEMENT_DAILY_RATE
, NEED_BY_DATE NEED_BY_DATE
, SOURCE_SUPPLY_ID SOURCE_SUPPLY_ID
, SR_MTL_SUPPLY_ID SR_MTL_SUPPLY_ID
, WIP_STATUS_CODE WIP_STATUS_CODE
, DEMAND_CLASS DEMAND_CLASS
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, PO_LINE_ID PO_LINE_ID
, LOAD_FACTOR_RATE LOAD_FACTOR_RATE
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY
, CFM_ROUTING_FLAG CFM_ROUTING_FLAG
, CUSTOMER_ID CUSTOMER_ID
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, OLD_NEED_BY_DATE OLD_NEED_BY_DATE
, OLD_DAILY_RATE OLD_DAILY_RATE
, OLD_FIRST_UNIT_START_DATE OLD_FIRST_UNIT_START_DATE
, OLD_LAST_UNIT_COMPLETION_DATE OLD_LAST_UNIT_COMPLETION_DATE
, OLD_NEW_SCHEDULE_DATE OLD_NEW_SCHEDULE_DATE
, OLD_QTY_COMPLETED OLD_QTY_COMPLETED
, OLD_NEW_ORDER_QUANTITY OLD_NEW_ORDER_QUANTITY
, OLD_FIRM_QUANTITY OLD_FIRM_QUANTITY
, OLD_FIRM_DATE OLD_FIRM_DATE
, 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
, EARLIEST_START_DATE EARLIEST_START_DATE
, EARLIEST_COMPLETION_DATE EARLIEST_COMPLETION_DATE
, MIN_START_DATE MIN_START_DATE
, SCHEDULED_DEMAND_ID SCHEDULED_DEMAND_ID
, EXPLOSION_DATE EXPLOSION_DATE
, SCO_SUPPLY_DATE SCO_SUPPLY_DATE
, RECORD_SOURCE RECORD_SOURCE
, SUPPLY_IS_SHARED SUPPLY_IS_SHARED
, ULPSD ULPSD
, ULPCD ULPCD
, UEPSD UEPSD
, UEPCD UEPCD
, EACD EACD
, ORIGINAL_NEED_BY_DATE ORIGINAL_NEED_BY_DATE
, ORIGINAL_QUANTITY ORIGINAL_QUANTITY
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, PROMISED_DATE PROMISED_DATE
, WIP_START_QUANTITY WIP_START_QUANTITY
, END_ORDER_NUMBER END_ORDER_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, ORDER_LINE_NUMBER ORDER_LINE_NUMBER
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, QUANTITY_ISSUED QUANTITY_ISSUED
, UNBUCKETED_DEMAND_DATE UNBUCKETED_DEMAND_DATE
, SHIPMENT_ID SHIPMENT_ID
, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM
, JUMP_OP_SEQ_NUM JUMP_OP_SEQ_NUM
, SHIP_CALENDAR SHIP_CALENDAR
, RECEIVING_CALENDAR RECEIVING_CALENDAR
, INTRANSIT_CALENDAR INTRANSIT_CALENDAR
, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME
, OLD_SHIP_DATE OLD_SHIP_DATE
, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE
, ORIG_SHIP_METHOD ORIG_SHIP_METHOD
, ORIG_INTRANSIT_LEAD_TIME ORIG_INTRANSIT_LEAD_TIME
, PARENT_ID PARENT_ID
, DAYS_LATE DAYS_LATE
, SCHEDULE_PRIORITY SCHEDULE_PRIORITY
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, WSM_FAULTY_NETWORK WSM_FAULTY_NETWORK
, IMPLEMENT_DEST_ORG_ID IMPLEMENT_DEST_ORG_ID
, IMPLEMENT_DEST_INST_ID IMPLEMENT_DEST_INST_ID
, REQUESTED_START_DATE REQUESTED_START_DATE
, REQUESTED_COMPLETION_DATE REQUESTED_COMPLETION_DATE
, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER
, ASSET_ITEM_ID ASSET_ITEM_ID
, TOP_TRANSACTION_ID TOP_TRANSACTION_ID
, UNBUCKETED_NEW_SCHED_DATE UNBUCKETED_NEW_SCHED_DATE
, IMPLEMENT_SHIP_METHOD IMPLEMENT_SHIP_METHOD
, ACTUAL_START_DATE ACTUAL_START_DATE
FROM "MSC"."MSC_STORE_SUPPLIES"