DBA Data[Home] [Help] [Dependency Information]

VIEW: MSC.MSC_SUPPLIES#

Object Details
Object Name: MSC_SUPPLIES#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
TRANSACTION_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
SCHEDULE_DESIGNATOR_ID NUMBER

REVISION VARCHAR2 (10)
UNIT_NUMBER VARCHAR2 (30)
NEW_SCHEDULE_DATE DATE
Yes
OLD_SCHEDULE_DATE DATE

NEW_WIP_START_DATE DATE

OLD_WIP_START_DATE DATE

FIRST_UNIT_COMPLETION_DATE DATE

LAST_UNIT_COMPLETION_DATE DATE

FIRST_UNIT_START_DATE DATE

LAST_UNIT_START_DATE DATE

DISPOSITION_ID NUMBER

DISPOSITION_STATUS_TYPE NUMBER

ORDER_TYPE NUMBER
Yes
SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

NEW_ORDER_QUANTITY NUMBER

OLD_ORDER_QUANTITY NUMBER

NEW_ORDER_PLACEMENT_DATE DATE

OLD_ORDER_PLACEMENT_DATE DATE

RESCHEDULE_DAYS NUMBER

RESCHEDULE_FLAG NUMBER

SCHEDULE_COMPRESS_DAYS NUMBER

NEW_PROCESSING_DAYS NUMBER

PURCH_LINE_NUM NUMBER

QUANTITY_IN_PROCESS NUMBER

IMPLEMENTED_QUANTITY NUMBER

FIRM_PLANNED_TYPE NUMBER
Yes
FIRM_QUANTITY NUMBER

FIRM_DATE DATE

IMPLEMENT_DEMAND_CLASS VARCHAR2 (30)
IMPLEMENT_DATE DATE

IMPLEMENT_QUANTITY NUMBER

IMPLEMENT_FIRM NUMBER

IMPLEMENT_WIP_CLASS_CODE VARCHAR2 (10)
IMPLEMENT_JOB_NAME VARCHAR2 (240)
IMPLEMENT_DOCK_DATE DATE

IMPLEMENT_STATUS_CODE NUMBER

IMPLEMENT_EMPLOYEE_ID NUMBER

IMPLEMENT_UOM_CODE VARCHAR2 (3)
IMPLEMENT_LOCATION_ID NUMBER

IMPLEMENT_SOURCE_ORG_ID NUMBER

IMPLEMENT_SR_INSTANCE_ID NUMBER

IMPLEMENT_SUPPLIER_ID NUMBER

IMPLEMENT_SUPPLIER_SITE_ID NUMBER

IMPLEMENT_AS NUMBER

RELEASE_STATUS NUMBER

LOAD_TYPE NUMBER

PROCESS_SEQ_ID NUMBER

SCO_SUPPLY_FLAG NUMBER

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
OPERATION_SEQ_NUM NUMBER

BY_PRODUCT_USING_ASSY_ID NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_SR_INSTANCE_ID NUMBER

SOURCE_SUPPLIER_SITE_ID NUMBER

SOURCE_SUPPLIER_ID NUMBER

SHIP_METHOD VARCHAR2 (30)
WEIGHT_CAPACITY_USED NUMBER

VOLUME_CAPACITY_USED NUMBER

NEW_SHIP_DATE DATE

NEW_DOCK_DATE DATE

OLD_DOCK_DATE DATE

LINE_ID NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
PLANNING_GROUP VARCHAR2 (30)
IMPLEMENT_PROJECT_ID NUMBER (15)
IMPLEMENT_TASK_ID NUMBER (15)
IMPLEMENT_SCHEDULE_GROUP_ID NUMBER

IMPLEMENT_BUILD_SEQUENCE NUMBER

IMPLEMENT_ALTERNATE_BOM VARCHAR2 (10)
IMPLEMENT_ALTERNATE_ROUTING VARCHAR2 (10)
IMPLEMENT_UNIT_NUMBER VARCHAR2 (30)
IMPLEMENT_LINE_ID NUMBER

RELEASE_ERRORS VARCHAR2 (250)
NUMBER1 NUMBER

SOURCE_ITEM_ID NUMBER

ORDER_NUMBER VARCHAR2 (240)
SCHEDULE_GROUP_ID NUMBER

BUILD_SEQUENCE NUMBER

WIP_ENTITY_NAME VARCHAR2 (240)
IMPLEMENT_PROCESSING_DAYS NUMBER

DELIVERY_PRICE NUMBER

LATE_SUPPLY_DATE DATE

LATE_SUPPLY_QTY NUMBER

LOT_NUMBER VARCHAR2 (80)
SUBINVENTORY_CODE VARCHAR2 (10)
QTY_SCRAPPED NUMBER

EXPECTED_SCRAP_QTY NUMBER

QTY_COMPLETED NUMBER

DAILY_RATE NUMBER

SCHEDULE_GROUP_NAME VARCHAR2 (30)
UPDATED NUMBER

SUBST_ITEM_FLAG NUMBER

STATUS NUMBER

APPLIED NUMBER

EXPIRATION_QUANTITY NUMBER

EXPIRATION_DATE DATE

NON_NETTABLE_QTY NUMBER

IMPLEMENT_WIP_START_DATE DATE

REFRESH_NUMBER NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

IMPLEMENT_DAILY_RATE NUMBER

NEED_BY_DATE DATE

SOURCE_SUPPLY_ID NUMBER

SR_MTL_SUPPLY_ID NUMBER

WIP_STATUS_CODE NUMBER

DEMAND_CLASS VARCHAR2 (34)
FROM_ORGANIZATION_ID NUMBER

WIP_SUPPLY_TYPE NUMBER

PO_LINE_ID NUMBER

LOAD_FACTOR_RATE NUMBER

ROUTING_SEQUENCE_ID NUMBER

BILL_SEQUENCE_ID NUMBER

COPRODUCTS_SUPPLY NUMBER

CFM_ROUTING_FLAG NUMBER

CUSTOMER_ID NUMBER

SHIP_TO_SITE_ID NUMBER

OLD_NEED_BY_DATE DATE

OLD_DAILY_RATE NUMBER

OLD_FIRST_UNIT_START_DATE DATE

OLD_LAST_UNIT_COMPLETION_DATE DATE

OLD_NEW_SCHEDULE_DATE DATE

OLD_QTY_COMPLETED NUMBER

OLD_NEW_ORDER_QUANTITY NUMBER

OLD_FIRM_QUANTITY NUMBER

OLD_FIRM_DATE DATE

PLANNING_PARTNER_SITE_ID NUMBER

PLANNING_TP_TYPE NUMBER

OWNING_PARTNER_SITE_ID NUMBER

OWNING_TP_TYPE NUMBER

VMI_FLAG NUMBER

EARLIEST_START_DATE DATE

EARLIEST_COMPLETION_DATE DATE

MIN_START_DATE DATE

SCHEDULED_DEMAND_ID NUMBER

EXPLOSION_DATE DATE

SCO_SUPPLY_DATE DATE

RECORD_SOURCE NUMBER

SUPPLY_IS_SHARED NUMBER

ULPSD DATE

ULPCD DATE

UEPSD DATE

UEPCD DATE

EACD DATE

ORIGINAL_NEED_BY_DATE DATE

ORIGINAL_QUANTITY NUMBER

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
PROMISED_DATE DATE

WIP_START_QUANTITY NUMBER

END_ORDER_NUMBER VARCHAR2 (240)
END_ORDER_LINE_NUMBER VARCHAR2 (25)
ORDER_LINE_NUMBER VARCHAR2 (25)
QUANTITY_PER_ASSEMBLY NUMBER

QUANTITY_ISSUED NUMBER

UNBUCKETED_DEMAND_DATE DATE

SHIPMENT_ID NUMBER

JOB_OP_SEQ_NUM NUMBER

JUMP_OP_SEQ_NUM NUMBER

SHIP_CALENDAR VARCHAR2 (15)
RECEIVING_CALENDAR VARCHAR2 (15)
INTRANSIT_CALENDAR VARCHAR2 (15)
INTRANSIT_LEAD_TIME NUMBER

OLD_SHIP_DATE VARCHAR2 (240)
IMPLEMENT_SHIP_DATE DATE

ORIG_SHIP_METHOD VARCHAR2 (30)
ORIG_INTRANSIT_LEAD_TIME NUMBER

PARENT_ID NUMBER

DAYS_LATE NUMBER

SCHEDULE_PRIORITY NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

WSM_FAULTY_NETWORK NUMBER

IMPLEMENT_DEST_ORG_ID NUMBER

IMPLEMENT_DEST_INST_ID NUMBER

REQUESTED_START_DATE DATE

REQUESTED_COMPLETION_DATE DATE

ASSET_SERIAL_NUMBER VARCHAR2 (30)
ASSET_ITEM_ID NUMBER

TOP_TRANSACTION_ID NUMBER

UNBUCKETED_NEW_SCHED_DATE DATE

IMPLEMENT_SHIP_METHOD VARCHAR2 (30)
ACTUAL_START_DATE DATE

FIRM_SHIP_DATE DATE

SCHEDULE_ORIGINATION_TYPE NUMBER

UNBUCKETED_START_DATE DATE

SR_CUSTOMER_ACCT_ID NUMBER

ITEM_TYPE_ID NUMBER

CUSTOMER_PRODUCT_ID NUMBER (15)
RO_STATUS_CODE VARCHAR2 (30)
SR_REPAIR_GROUP_ID NUMBER

SR_REPAIR_TYPE_ID NUMBER (15)
ITEM_TYPE_VALUE NUMBER

ZONE_ID NUMBER

RO_CREATION_DATE DATE

REPAIR_LEAD_TIME NUMBER

FIRM_START_DATE DATE

REQ_LINE_ID NUMBER

INTRANSIT_OWNING_ORG_ID NUMBER

RELEASABLE NUMBER

BATCH_ID NUMBER

OTM_ARRIVAL_DATE DATE

PS_SUPPLY_FLAG NUMBER

CTB_FLAG VARCHAR2 (1)
CTB_COMP_AVAIL_PERCENT NUMBER

RTB_ORDER_QTY_PERCENT NUMBER

CTB_EXPECTED_DATE DATE

POTENTIAL_RTB_PERCENT NUMBER

CTB_PRIORITY NUMBER

DESCRIPTION VARCHAR2 (240)
MAINTENANCE_OBJECT_SOURCE NUMBER

PRODUCTION_SCHEDULE_ID NUMBER

VISIT_ID NUMBER

PRODUCES_TO_STOCK NUMBER

PRODUCT_CLASSIFICATION VARCHAR2 (150)
MAINTENANCE_REQT VARCHAR2 (80)
ACTIVITY_TYPE NUMBER

ACTIVITY_NAME VARCHAR2 (250)
CLASS_CODE VARCHAR2 (10)
SHUTDOWN_TYPE NUMBER

TO_BE_EXPLODED NUMBER

OBJECT_TYPE VARCHAR2 (3)
MAINTENANCE_TYPE_CODE VARCHAR2 (30)
ACTIVITY_ITEM_ID NUMBER

ORIG_FIRM_DATE DATE

ORIG_FIRM_QUANTITY NUMBER

USE_WO_SUBSTITUTE NUMBER

ASSET_NUMBER VARCHAR2 (30)
MAINTENANCE_OBJECT_ID NUMBER

MAINTENANCE_OBJECT_TYPE NUMBER

OPERATING_FLEET NUMBER

MAINTENANCE_REQUIREMENT VARCHAR2 (22)
COLL_ORDER_TYPE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_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_SR_INSTANCE_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_SR_INSTANCE_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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      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
,      WIP_START_QUANTITY
,      END_ORDER_NUMBER
,      END_ORDER_LINE_NUMBER
,      ORDER_LINE_NUMBER
,      QUANTITY_PER_ASSEMBLY
,      QUANTITY_ISSUED
,      UNBUCKETED_DEMAND_DATE
,      SHIPMENT_ID
,      JOB_OP_SEQ_NUM
,      JUMP_OP_SEQ_NUM
,      SHIP_CALENDAR
,      RECEIVING_CALENDAR
,      INTRANSIT_CALENDAR
,      INTRANSIT_LEAD_TIME
,      OLD_SHIP_DATE
,      IMPLEMENT_SHIP_DATE
,      ORIG_SHIP_METHOD
,      ORIG_INTRANSIT_LEAD_TIME
,      PARENT_ID
,      DAYS_LATE
,      SCHEDULE_PRIORITY
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      WSM_FAULTY_NETWORK
,      IMPLEMENT_DEST_ORG_ID
,      IMPLEMENT_DEST_INST_ID
,      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
,      SCHEDULE_ORIGINATION_TYPE
,      UNBUCKETED_START_DATE
,      SR_CUSTOMER_ACCT_ID
,      ITEM_TYPE_ID
,      CUSTOMER_PRODUCT_ID
,      RO_STATUS_CODE
,      SR_REPAIR_GROUP_ID
,      SR_REPAIR_TYPE_ID
,      ITEM_TYPE_VALUE
,      ZONE_ID
,      RO_CREATION_DATE
,      REPAIR_LEAD_TIME
,      FIRM_START_DATE
,      REQ_LINE_ID
,      INTRANSIT_OWNING_ORG_ID
,      RELEASABLE
,      BATCH_ID
,      OTM_ARRIVAL_DATE
,      PS_SUPPLY_FLAG
,      CTB_FLAG
,      CTB_COMP_AVAIL_PERCENT
,      RTB_ORDER_QTY_PERCENT
,      CTB_EXPECTED_DATE
,      POTENTIAL_RTB_PERCENT
,      CTB_PRIORITY
,      DESCRIPTION
,      MAINTENANCE_OBJECT_SOURCE
,      PRODUCTION_SCHEDULE_ID
,      VISIT_ID
,      PRODUCES_TO_STOCK
,      PRODUCT_CLASSIFICATION
,      MAINTENANCE_REQT
,      ACTIVITY_TYPE
,      ACTIVITY_NAME
,      CLASS_CODE
,      SHUTDOWN_TYPE
,      TO_BE_EXPLODED
,      OBJECT_TYPE
,      MAINTENANCE_TYPE_CODE
,      ACTIVITY_ITEM_ID
,      ORIG_FIRM_DATE
,      ORIG_FIRM_QUANTITY
,      USE_WO_SUBSTITUTE
,      ASSET_NUMBER
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      OPERATING_FLEET
,      MAINTENANCE_REQUIREMENT
,      COLL_ORDER_TYPE
FROM MSC.MSC_SUPPLIES#;

Dependencies

[top of page]

MSC.MSC_SUPPLIES# references the following:

SchemaMSC
TableMSC_SUPPLIES
MSC.MSC_SUPPLIES# is referenced by following:

SchemaAPPS
SynonymMSC_SUPPLIES