MSC_SUPPLIESRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID SERVICE_LEVEL TRANSACTION_ID ORGANIZATION_ID INVENTORY_ITEM_ID SCHEDULE_DESIGNATOR_ID REVISION UNIT_NUMBER NEW_SCHEDULE_DATE OLD_SCHEDULE_DATE NEW_WIP_START_DATE OLD_WIP_START_DATE FIRST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE FIRST_UNIT_START_DATE LAST_UNIT_START_DATE DISPOSITION_ID DISPOSITION_STATUS_TYPE ORDER_TYPE SUPPLIER_ID SUPPLIER_SITE_ID NEW_ORDER_QUANTITY OLD_ORDER_QUANTITY NEW_ORDER_PLACEMENT_DATE OLD_ORDER_PLACEMENT_DATE RESCHEDULE_DAYS RESCHEDULE_FLAG SCHEDULE_COMPRESS_DAYS NEW_PROCESSING_DAYS PURCH_LINE_NUM QUANTITY_IN_PROCESS IMPLEMENTED_QUANTITY FIRM_PLANNED_TYPE FIRM_QUANTITY FIRM_DATE IMPLEMENT_DEMAND_CLASS IMPLEMENT_DATE IMPLEMENT_QUANTITY IMPLEMENT_FIRM IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_JOB_NAME IMPLEMENT_DOCK_DATE IMPLEMENT_STATUS_CODE IMPLEMENT_EMPLOYEE_ID IMPLEMENT_UOM_CODE IMPLEMENT_LOCATION_ID IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SUPPLIER_ID IMPLEMENT_SUPPLIER_SITE_ID IMPLEMENT_AS RELEASE_STATUS LOAD_TYPE PROCESS_SEQ_ID SCO_SUPPLY_FLAG ALTERNATE_BOM_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR OPERATION_SEQ_NUM BY_PRODUCT_USING_ASSY_ID SOURCE_ORGANIZATION_ID SOURCE_SUPPLIER_SITE_ID SOURCE_SUPPLIER_ID SHIP_METHOD WEIGHT_CAPACITY_USED VOLUME_CAPACITY_USED NEW_SHIP_DATE NEW_DOCK_DATE OLD_DOCK_DATE LINE_ID PROJECT_ID TASK_ID PLANNING_GROUP IMPLEMENT_PROJECT_ID IMPLEMENT_TASK_ID IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_ROUTING IMPLEMENT_UNIT_NUMBER IMPLEMENT_LINE_ID RELEASE_ERRORS NUMBER1 SOURCE_ITEM_ID ORDER_NUMBER SCHEDULE_GROUP_ID BUILD_SEQUENCE WIP_ENTITY_NAME IMPLEMENT_PROCESSING_DAYS DELIVERY_PRICE LATE_SUPPLY_DATE LATE_SUPPLY_QTY LOT_NUMBER SUBINVENTORY_CODE QTY_SCRAPPED EXPECTED_SCRAP_QTY QTY_COMPLETED DAILY_RATE SCHEDULE_GROUP_NAME UPDATED SUBST_ITEM_FLAG STATUS APPLIED EXPIRATION_QUANTITY EXPIRATION_DATE NON_NETTABLE_QTY IMPLEMENT_WIP_START_DATE REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN IMPLEMENT_DAILY_RATE NEED_BY_DATE SOURCE_SUPPLY_ID SR_MTL_SUPPLY_ID WIP_STATUS_CODE DEMAND_CLASS FROM_ORGANIZATION_ID WIP_SUPPLY_TYPE PO_LINE_ID LOAD_FACTOR_RATE ROUTING_SEQUENCE_ID BILL_SEQUENCE_ID COPRODUCTS_SUPPLY CFM_ROUTING_FLAG CUSTOMER_ID SHIP_TO_SITE_ID OLD_NEED_BY_DATE OLD_DAILY_RATE OLD_FIRST_UNIT_START_DATE OLD_LAST_UNIT_COMPLETION_DATE OLD_NEW_SCHEDULE_DATE CARRIER_ID MODE_OF_TRANSPORT OLD_QTY_COMPLETED OLD_NEW_ORDER_QUANTITY OLD_FIRM_QUANTITY OLD_FIRM_DATE PLANNING_PARTNER_SITE_ID PLANNING_TP_TYPE OWNING_PARTNER_SITE_ID OWNING_TP_TYPE VMI_FLAG EARLIEST_START_DATE EARLIEST_COMPLETION_DATE MIN_START_DATE SCHEDULED_DEMAND_ID EXPLOSION_DATE SCO_SUPPLY_DATE RECORD_SOURCE SUPPLY_IS_SHARED ULPSD ULPCD UEPSD UEPCD EACD ORIGINAL_NEED_BY_DATE ORIGINAL_QUANTITY ACCEPTANCE_REQUIRED_FLAG PROMISED_DATE START_QUANTITY END_ORDER_NUMBER END_ORDER_LINE_NUMBER ORDER_LINE_NUMBER UNBUCKETED_DEMAND_DATE DAYS_LATE IMPLEMENT_DEST_INST_ID IMPLEMENT_DEST_ORG_ID IMPLEMENT_SHIP_DATE INTRANSIT_CALENDAR INTRANSIT_LEAD_TIME JOB_OP_SEQ_NUM JUMP_OP_SEQ_NUM OLD_SHIP_DATE ORIG_INTRANSIT_LEAD_TIME ORIG_SHIP_METHOD PARENT_ID PO_DISTRIBUTION_ID PO_LINE_LOCATION_ID QUANTITY_ISSUED QUANTITY_PER_ASSEMBLY RECEIVING_CALENDAR SCHEDULE_PRIORITY SHIPMENT_ID SHIP_CALENDAR WSM_FAULTY_NETWORK REQUESTED_START_DATE REQUESTED_COMPLETION_DATE ASSET_SERIAL_NUMBER ASSET_ITEM_ID TOP_TRANSACTION_ID UNBUCKETED_NEW_SCHED_DATE IMPLEMENT_SHIP_METHOD ACTUAL_START_DATE FIRM_SHIP_DATE OBJECT_VERSION_NUMBER INTERFACE_STATUS_LOOKUP DROP_SHIP_CUST_ID DROP_SHIP_CUST_SITE_ID TO_LINE_ID FULFILL_ORCHESTRATION_REQUIRED FG_ORDER_TYPE

Name

PLAN_ID

SERVICE_LEVEL

TRANSACTION_ID

ORGANIZATION_ID

INVENTORY_ITEM_ID

SCHEDULE_DESIGNATOR_ID

REVISION

UNIT_NUMBER

NEW_SCHEDULE_DATE

OLD_SCHEDULE_DATE

NEW_WIP_START_DATE

OLD_WIP_START_DATE

FIRST_UNIT_COMPLETION_DATE

LAST_UNIT_COMPLETION_DATE

FIRST_UNIT_START_DATE

LAST_UNIT_START_DATE

DISPOSITION_ID

DISPOSITION_STATUS_TYPE

ORDER_TYPE

SUPPLIER_ID

SUPPLIER_SITE_ID

NEW_ORDER_QUANTITY

OLD_ORDER_QUANTITY

NEW_ORDER_PLACEMENT_DATE

OLD_ORDER_PLACEMENT_DATE

RESCHEDULE_DAYS

RESCHEDULE_FLAG

SCHEDULE_COMPRESS_DAYS

NEW_PROCESSING_DAYS

PURCH_LINE_NUM

QUANTITY_IN_PROCESS

IMPLEMENTED_QUANTITY

FIRM_PLANNED_TYPE

FIRM_QUANTITY

FIRM_DATE

IMPLEMENT_DEMAND_CLASS

IMPLEMENT_DATE

IMPLEMENT_QUANTITY

IMPLEMENT_FIRM

IMPLEMENT_WIP_CLASS_CODE

IMPLEMENT_JOB_NAME

IMPLEMENT_DOCK_DATE

IMPLEMENT_STATUS_CODE

IMPLEMENT_EMPLOYEE_ID

IMPLEMENT_UOM_CODE

IMPLEMENT_LOCATION_ID

IMPLEMENT_SOURCE_ORG_ID

IMPLEMENT_SUPPLIER_ID

IMPLEMENT_SUPPLIER_SITE_ID

IMPLEMENT_AS

RELEASE_STATUS

LOAD_TYPE

PROCESS_SEQ_ID

SCO_SUPPLY_FLAG

ALTERNATE_BOM_DESIGNATOR

ALTERNATE_ROUTING_DESIGNATOR

OPERATION_SEQ_NUM

BY_PRODUCT_USING_ASSY_ID

SOURCE_ORGANIZATION_ID

SOURCE_SUPPLIER_SITE_ID

SOURCE_SUPPLIER_ID

SHIP_METHOD

WEIGHT_CAPACITY_USED

VOLUME_CAPACITY_USED

NEW_SHIP_DATE

NEW_DOCK_DATE

OLD_DOCK_DATE

LINE_ID

PROJECT_ID

TASK_ID

PLANNING_GROUP

IMPLEMENT_PROJECT_ID

IMPLEMENT_TASK_ID

IMPLEMENT_SCHEDULE_GROUP_ID

IMPLEMENT_BUILD_SEQUENCE

IMPLEMENT_ALTERNATE_BOM

IMPLEMENT_ALTERNATE_ROUTING

IMPLEMENT_UNIT_NUMBER

IMPLEMENT_LINE_ID

RELEASE_ERRORS

NUMBER1

SOURCE_ITEM_ID

ORDER_NUMBER

SCHEDULE_GROUP_ID

BUILD_SEQUENCE

WIP_ENTITY_NAME

IMPLEMENT_PROCESSING_DAYS

DELIVERY_PRICE

LATE_SUPPLY_DATE

LATE_SUPPLY_QTY

LOT_NUMBER

SUBINVENTORY_CODE

QTY_SCRAPPED

EXPECTED_SCRAP_QTY

QTY_COMPLETED

DAILY_RATE

SCHEDULE_GROUP_NAME

UPDATED

SUBST_ITEM_FLAG

STATUS

APPLIED

EXPIRATION_QUANTITY

EXPIRATION_DATE

NON_NETTABLE_QTY

IMPLEMENT_WIP_START_DATE

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

IMPLEMENT_DAILY_RATE

NEED_BY_DATE

SOURCE_SUPPLY_ID

SR_MTL_SUPPLY_ID

WIP_STATUS_CODE

DEMAND_CLASS

FROM_ORGANIZATION_ID

WIP_SUPPLY_TYPE

PO_LINE_ID

LOAD_FACTOR_RATE

ROUTING_SEQUENCE_ID

BILL_SEQUENCE_ID

COPRODUCTS_SUPPLY

CFM_ROUTING_FLAG

CUSTOMER_ID

SHIP_TO_SITE_ID

OLD_NEED_BY_DATE

OLD_DAILY_RATE

OLD_FIRST_UNIT_START_DATE

OLD_LAST_UNIT_COMPLETION_DATE

OLD_NEW_SCHEDULE_DATE

CARRIER_ID

MODE_OF_TRANSPORT

OLD_QTY_COMPLETED

OLD_NEW_ORDER_QUANTITY

OLD_FIRM_QUANTITY

OLD_FIRM_DATE

PLANNING_PARTNER_SITE_ID

PLANNING_TP_TYPE

OWNING_PARTNER_SITE_ID

OWNING_TP_TYPE

VMI_FLAG

EARLIEST_START_DATE

EARLIEST_COMPLETION_DATE

MIN_START_DATE

SCHEDULED_DEMAND_ID

EXPLOSION_DATE

SCO_SUPPLY_DATE

RECORD_SOURCE

SUPPLY_IS_SHARED

ULPSD

ULPCD

UEPSD

UEPCD

EACD

ORIGINAL_NEED_BY_DATE

ORIGINAL_QUANTITY

ACCEPTANCE_REQUIRED_FLAG

PROMISED_DATE

START_QUANTITY

END_ORDER_NUMBER

END_ORDER_LINE_NUMBER

ORDER_LINE_NUMBER

UNBUCKETED_DEMAND_DATE

DAYS_LATE

IMPLEMENT_DEST_INST_ID

IMPLEMENT_DEST_ORG_ID

IMPLEMENT_SHIP_DATE

INTRANSIT_CALENDAR

INTRANSIT_LEAD_TIME

JOB_OP_SEQ_NUM

JUMP_OP_SEQ_NUM

OLD_SHIP_DATE

ORIG_INTRANSIT_LEAD_TIME

ORIG_SHIP_METHOD

PARENT_ID

PO_DISTRIBUTION_ID

PO_LINE_LOCATION_ID

QUANTITY_ISSUED

QUANTITY_PER_ASSEMBLY

RECEIVING_CALENDAR

SCHEDULE_PRIORITY

SHIPMENT_ID

SHIP_CALENDAR

WSM_FAULTY_NETWORK

REQUESTED_START_DATE

REQUESTED_COMPLETION_DATE

ASSET_SERIAL_NUMBER

ASSET_ITEM_ID

TOP_TRANSACTION_ID

UNBUCKETED_NEW_SCHED_DATE

IMPLEMENT_SHIP_METHOD

ACTUAL_START_DATE

FIRM_SHIP_DATE

OBJECT_VERSION_NUMBER

INTERFACE_STATUS_LOOKUP

DROP_SHIP_CUST_ID

DROP_SHIP_CUST_SITE_ID

TO_LINE_ID

FULFILL_ORCHESTRATION_REQUIRED

FG_ORDER_TYPE

Query

SQL_Statement
select "PLAN_ID","SERVICE_LEVEL","TRANSACTION_ID","ORGANIZATION_ID","INVENTORY_ITEM_ID","SCHEDULE_DESIGNATOR_ID","REVISION","UNIT_NUMBER","NEW_SCHEDULE_DATE","OLD_SCHEDULE_DATE","NEW_WIP_START_DATE","OLD_WIP_START_DATE","FIRST_UNIT_COMPLETION_DATE","LAST_UNIT_COMPLETION_DATE","FIRST_UNIT_START_DATE","LAST_UNIT_START_DATE","DISPOSITION_ID","DISPOSITION_STATUS_TYPE","ORDER_TYPE","SUPPLIER_ID","SUPPLIER_SITE_ID","NEW_ORDER_QUANTITY","OLD_ORDER_QUANTITY","NEW_ORDER_PLACEMENT_DATE","OLD_ORDER_PLACEMENT_DATE","RESCHEDULE_DAYS","RESCHEDULE_FLAG","SCHEDULE_COMPRESS_DAYS","NEW_PROCESSING_DAYS","PURCH_LINE_NUM","QUANTITY_IN_PROCESS","IMPLEMENTED_QUANTITY","FIRM_PLANNED_TYPE","FIRM_QUANTITY","FIRM_DATE","IMPLEMENT_DEMAND_CLASS","IMPLEMENT_DATE","IMPLEMENT_QUANTITY","IMPLEMENT_FIRM","IMPLEMENT_WIP_CLASS_CODE","IMPLEMENT_JOB_NAME","IMPLEMENT_DOCK_DATE","IMPLEMENT_STATUS_CODE","IMPLEMENT_EMPLOYEE_ID","IMPLEMENT_UOM_CODE","IMPLEMENT_LOCATION_ID","IMPLEMENT_SOURCE_ORG_ID","IMPLEMENT_SUPPLIER_ID","IMPLEMENT_SUPPLIER_SITE_ID","IMPLEMENT_AS","RELEASE_STATUS","LOAD_TYPE","PROCESS_SEQ_ID","SCO_SUPPLY_FLAG","ALTERNATE_BOM_DESIGNATOR","ALTERNATE_ROUTING_DESIGNATOR","OPERATION_SEQ_NUM","BY_PRODUCT_USING_ASSY_ID","SOURCE_ORGANIZATION_ID","SOURCE_SUPPLIER_SITE_ID","SOURCE_SUPPLIER_ID","SHIP_METHOD","WEIGHT_CAPACITY_USED","VOLUME_CAPACITY_USED","NEW_SHIP_DATE","NEW_DOCK_DATE","OLD_DOCK_DATE","LINE_ID","PROJECT_ID","TASK_ID","PLANNING_GROUP","IMPLEMENT_PROJECT_ID","IMPLEMENT_TASK_ID","IMPLEMENT_SCHEDULE_GROUP_ID","IMPLEMENT_BUILD_SEQUENCE","IMPLEMENT_ALTERNATE_BOM","IMPLEMENT_ALTERNATE_ROUTING","IMPLEMENT_UNIT_NUMBER","IMPLEMENT_LINE_ID","RELEASE_ERRORS","NUMBER1","SOURCE_ITEM_ID","ORDER_NUMBER","SCHEDULE_GROUP_ID","BUILD_SEQUENCE","WIP_ENTITY_NAME","IMPLEMENT_PROCESSING_DAYS","DELIVERY_PRICE","LATE_SUPPLY_DATE","LATE_SUPPLY_QTY","LOT_NUMBER","SUBINVENTORY_CODE","QTY_SCRAPPED","EXPECTED_SCRAP_QTY","QTY_COMPLETED","DAILY_RATE","SCHEDULE_GROUP_NAME","UPDATED","SUBST_ITEM_FLAG","STATUS","APPLIED","EXPIRATION_QUANTITY","EXPIRATION_DATE","NON_NETTABLE_QTY","IMPLEMENT_WIP_START_DATE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","IMPLEMENT_DAILY_RATE","NEED_BY_DATE","SOURCE_SUPPLY_ID","SR_MTL_SUPPLY_ID","WIP_STATUS_CODE","DEMAND_CLASS","FROM_ORGANIZATION_ID","WIP_SUPPLY_TYPE","PO_LINE_ID","LOAD_FACTOR_RATE","ROUTING_SEQUENCE_ID","BILL_SEQUENCE_ID","COPRODUCTS_SUPPLY","CFM_ROUTING_FLAG","CUSTOMER_ID","SHIP_TO_SITE_ID","OLD_NEED_BY_DATE","OLD_DAILY_RATE","OLD_FIRST_UNIT_START_DATE","OLD_LAST_UNIT_COMPLETION_DATE","OLD_NEW_SCHEDULE_DATE","CARRIER_ID","MODE_OF_TRANSPORT","OLD_QTY_COMPLETED","OLD_NEW_ORDER_QUANTITY","OLD_FIRM_QUANTITY","OLD_FIRM_DATE","PLANNING_PARTNER_SITE_ID","PLANNING_TP_TYPE","OWNING_PARTNER_SITE_ID","OWNING_TP_TYPE","VMI_FLAG","EARLIEST_START_DATE","EARLIEST_COMPLETION_DATE","MIN_START_DATE","SCHEDULED_DEMAND_ID","EXPLOSION_DATE","SCO_SUPPLY_DATE","RECORD_SOURCE","SUPPLY_IS_SHARED","ULPSD","ULPCD","UEPSD","UEPCD","EACD","ORIGINAL_NEED_BY_DATE","ORIGINAL_QUANTITY","ACCEPTANCE_REQUIRED_FLAG","PROMISED_DATE","START_QUANTITY","END_ORDER_NUMBER","END_ORDER_LINE_NUMBER","ORDER_LINE_NUMBER","UNBUCKETED_DEMAND_DATE","DAYS_LATE","IMPLEMENT_DEST_INST_ID","IMPLEMENT_DEST_ORG_ID","IMPLEMENT_SHIP_DATE","INTRANSIT_CALENDAR","INTRANSIT_LEAD_TIME","JOB_OP_SEQ_NUM","JUMP_OP_SEQ_NUM","OLD_SHIP_DATE","ORIG_INTRANSIT_LEAD_TIME","ORIG_SHIP_METHOD","PARENT_ID","PO_DISTRIBUTION_ID","PO_LINE_LOCATION_ID","QUANTITY_ISSUED","QUANTITY_PER_ASSEMBLY","RECEIVING_CALENDAR","SCHEDULE_PRIORITY","SHIPMENT_ID","SHIP_CALENDAR","WSM_FAULTY_NETWORK","REQUESTED_START_DATE","REQUESTED_COMPLETION_DATE","ASSET_SERIAL_NUMBER","ASSET_ITEM_ID","TOP_TRANSACTION_ID","UNBUCKETED_NEW_SCHED_DATE","IMPLEMENT_SHIP_METHOD","ACTUAL_START_DATE","FIRM_SHIP_DATE","OBJECT_VERSION_NUMBER","INTERFACE_STATUS_LOOKUP","DROP_SHIP_CUST_ID","DROP_SHIP_CUST_SITE_ID","TO_LINE_ID","FULFILL_ORCHESTRATION_REQUIRED","FG_ORDER_TYPE" from msc_supplies as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "PLAN_ID","SERVICE_LEVEL","TRANSACTION_ID","ORGANIZATION_ID","INVENTORY_ITEM_ID","SCHEDULE_DESIGNATOR_ID","REVISION","UNIT_NUMBER","NEW_SCHEDULE_DATE","OLD_SCHEDULE_DATE","NEW_WIP_START_DATE","OLD_WIP_START_DATE","FIRST_UNIT_COMPLETION_DATE","LAST_UNIT_COMPLETION_DATE","FIRST_UNIT_START_DATE","LAST_UNIT_START_DATE","DISPOSITION_ID","DISPOSITION_STATUS_TYPE","ORDER_TYPE","SUPPLIER_ID","SUPPLIER_SITE_ID","NEW_ORDER_QUANTITY","OLD_ORDER_QUANTITY","NEW_ORDER_PLACEMENT_DATE","OLD_ORDER_PLACEMENT_DATE","RESCHEDULE_DAYS","RESCHEDULE_FLAG","SCHEDULE_COMPRESS_DAYS","NEW_PROCESSING_DAYS","PURCH_LINE_NUM","QUANTITY_IN_PROCESS","IMPLEMENTED_QUANTITY","FIRM_PLANNED_TYPE","FIRM_QUANTITY","FIRM_DATE","IMPLEMENT_DEMAND_CLASS","IMPLEMENT_DATE","IMPLEMENT_QUANTITY","IMPLEMENT_FIRM","IMPLEMENT_WIP_CLASS_CODE","IMPLEMENT_JOB_NAME","IMPLEMENT_DOCK_DATE","IMPLEMENT_STATUS_CODE","IMPLEMENT_EMPLOYEE_ID","IMPLEMENT_UOM_CODE","IMPLEMENT_LOCATION_ID","IMPLEMENT_SOURCE_ORG_ID","IMPLEMENT_SUPPLIER_ID","IMPLEMENT_SUPPLIER_SITE_ID","IMPLEMENT_AS","RELEASE_STATUS","LOAD_TYPE","PROCESS_SEQ_ID","SCO_SUPPLY_FLAG","ALTERNATE_BOM_DESIGNATOR","ALTERNATE_ROUTING_DESIGNATOR","OPERATION_SEQ_NUM","BY_PRODUCT_USING_ASSY_ID","SOURCE_ORGANIZATION_ID","SOURCE_SUPPLIER_SITE_ID","SOURCE_SUPPLIER_ID","SHIP_METHOD","WEIGHT_CAPACITY_USED","VOLUME_CAPACITY_USED","NEW_SHIP_DATE","NEW_DOCK_DATE","OLD_DOCK_DATE","LINE_ID","PROJECT_ID","TASK_ID","PLANNING_GROUP","IMPLEMENT_PROJECT_ID","IMPLEMENT_TASK_ID","IMPLEMENT_SCHEDULE_GROUP_ID","IMPLEMENT_BUILD_SEQUENCE","IMPLEMENT_ALTERNATE_BOM","IMPLEMENT_ALTERNATE_ROUTING","IMPLEMENT_UNIT_NUMBER","IMPLEMENT_LINE_ID","RELEASE_ERRORS","NUMBER1","SOURCE_ITEM_ID","ORDER_NUMBER","SCHEDULE_GROUP_ID","BUILD_SEQUENCE","WIP_ENTITY_NAME","IMPLEMENT_PROCESSING_DAYS","DELIVERY_PRICE","LATE_SUPPLY_DATE","LATE_SUPPLY_QTY","LOT_NUMBER","SUBINVENTORY_CODE","QTY_SCRAPPED","EXPECTED_SCRAP_QTY","QTY_COMPLETED","DAILY_RATE","SCHEDULE_GROUP_NAME","UPDATED","SUBST_ITEM_FLAG","STATUS","APPLIED","EXPIRATION_QUANTITY","EXPIRATION_DATE","NON_NETTABLE_QTY","IMPLEMENT_WIP_START_DATE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","IMPLEMENT_DAILY_RATE","NEED_BY_DATE","SOURCE_SUPPLY_ID","SR_MTL_SUPPLY_ID","WIP_STATUS_CODE","DEMAND_CLASS","FROM_ORGANIZATION_ID","WIP_SUPPLY_TYPE","PO_LINE_ID","LOAD_FACTOR_RATE","ROUTING_SEQUENCE_ID","BILL_SEQUENCE_ID","COPRODUCTS_SUPPLY","CFM_ROUTING_FLAG","CUSTOMER_ID","SHIP_TO_SITE_ID","OLD_NEED_BY_DATE","OLD_DAILY_RATE","OLD_FIRST_UNIT_START_DATE","OLD_LAST_UNIT_COMPLETION_DATE","OLD_NEW_SCHEDULE_DATE","CARRIER_ID","MODE_OF_TRANSPORT","OLD_QTY_COMPLETED","OLD_NEW_ORDER_QUANTITY","OLD_FIRM_QUANTITY","OLD_FIRM_DATE","PLANNING_PARTNER_SITE_ID","PLANNING_TP_TYPE","OWNING_PARTNER_SITE_ID","OWNING_TP_TYPE","VMI_FLAG","EARLIEST_START_DATE","EARLIEST_COMPLETION_DATE","MIN_START_DATE","SCHEDULED_DEMAND_ID","EXPLOSION_DATE","SCO_SUPPLY_DATE","RECORD_SOURCE","SUPPLY_IS_SHARED","ULPSD","ULPCD","UEPSD","UEPCD","EACD","ORIGINAL_NEED_BY_DATE","ORIGINAL_QUANTITY","ACCEPTANCE_REQUIRED_FLAG","PROMISED_DATE","START_QUANTITY","END_ORDER_NUMBER","END_ORDER_LINE_NUMBER","ORDER_LINE_NUMBER","UNBUCKETED_DEMAND_DATE","DAYS_LATE","IMPLEMENT_DEST_INST_ID","IMPLEMENT_DEST_ORG_ID","IMPLEMENT_SHIP_DATE","INTRANSIT_CALENDAR","INTRANSIT_LEAD_TIME","JOB_OP_SEQ_NUM","JUMP_OP_SEQ_NUM","OLD_SHIP_DATE","ORIG_INTRANSIT_LEAD_TIME","ORIG_SHIP_METHOD","PARENT_ID","PO_DISTRIBUTION_ID","PO_LINE_LOCATION_ID","QUANTITY_ISSUED","QUANTITY_PER_ASSEMBLY","RECEIVING_CALENDAR","SCHEDULE_PRIORITY","SHIPMENT_ID","SHIP_CALENDAR","WSM_FAULTY_NETWORK","REQUESTED_START_DATE","REQUESTED_COMPLETION_DATE","ASSET_SERIAL_NUMBER","ASSET_ITEM_ID","TOP_TRANSACTION_ID","UNBUCKETED_NEW_SCHED_DATE","IMPLEMENT_SHIP_METHOD","ACTUAL_START_DATE","FIRM_SHIP_DATE","OBJECT_VERSION_NUMBER","INTERFACE_STATUS_LOOKUP","DROP_SHIP_CUST_ID","DROP_SHIP_CUST_SITE_ID","TO_LINE_ID","FULFILL_ORCHESTRATION_REQUIRED","FG_ORDER_TYPE" from msc_supplies as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))