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

VIEW: MSC.MSC_ST_SUPPLIES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

TRANSACTION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

SCHEDULE_DESIGNATOR_ID NUMBER

SOURCE_SCHEDULE_NAME VARCHAR2 (10)
REVISION VARCHAR2 (10)
UNIT_NUMBER VARCHAR2 (30)
NEW_SCHEDULE_DATE DATE

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

SUPPLIER_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

FIRM_QUANTITY NUMBER

FIRM_DATE DATE

IMPLEMENT_DEMAND_CLASS VARCHAR2 (34)
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_UOM_CODE VARCHAR2 (3)
IMPLEMENT_LOCATION_ID NUMBER

IMPLEMENT_SOURCE_ORG_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

SOURCE 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 NUMBER

WEIGHT_CAPACITY_USED NUMBER

VOLUME_CAPACITY_USED NUMBER

SOURCE_SUPPLY_SCHEDULE_NAME NUMBER

NEW_SHIP_DATE DATE

NEW_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 (1)
NUMBER1 NUMBER

SOURCE_ITEM_ID NUMBER

ORDER_NUMBER VARCHAR2 (240)
SCHEDULE_GROUP_ID NUMBER

SCHEDULE_GROUP_NAME VARCHAR2 (30)
BUILD_SEQUENCE NUMBER

WIP_ENTITY_ID NUMBER

WIP_ENTITY_NAME VARCHAR2 (240)
WO_LATENESS_COST NUMBER

IMPLEMENT_PROCESSING_DAYS NUMBER

DELIVERY_PRICE NUMBER

LATE_SUPPLY_DATE DATE

LATE_SUPPLY_QTY NUMBER

SUBINVENTORY_CODE VARCHAR2 (10)
DELETED_FLAG NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_INSTANCE_ID NUMBER

SCHEDULE_DESIGNATOR VARCHAR2 (10)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

SUPPLIER_SITE_ID NUMBER

PURCH_ORDER_ID NUMBER

EXPECTED_SCRAP_QTY NUMBER

QTY_SCRAPPED NUMBER

QTY_COMPLETED NUMBER

LOT_NUMBER VARCHAR2 (80)
EXPIRATION_DATE DATE

WIP_STATUS_CODE NUMBER

DAILY_RATE NUMBER

LOCATOR_ID NUMBER

SERIAL_NUMBER VARCHAR2 (30)
REFRESH_ID NUMBER

LOCATOR_NAME VARCHAR2 (204)
ONHAND_SOURCE_TYPE NUMBER

SR_MTL_SUPPLY_ID NUMBER

DEMAND_CLASS VARCHAR2 (34)
FROM_ORGANIZATION_ID NUMBER

WIP_SUPPLY_TYPE NUMBER

PO_LINE_ID NUMBER

BILL_SEQUENCE_ID NUMBER

ROUTING_SEQUENCE_ID NUMBER

COPRODUCTS_SUPPLY NUMBER

CFM_ROUTING_FLAG NUMBER

COMPANY_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
ITEM_NAME VARCHAR2 (250)
ORGANIZATION_CODE VARCHAR2 (7)
FROM_ORGANIZATION_CODE VARCHAR2 (7)
SUPPLIER_NAME VARCHAR2 (255)
SOURCE_SR_INSTANCE_CODE VARCHAR2 (3)
SOURCE_SUPPLIER_SITE_CODE VARCHAR2 (30)
SOURCE_SUPPLIER_NAME VARCHAR2 (80)
PROJECT_NUMBER VARCHAR2 (25)
TASK_NUMBER VARCHAR2 (25)
SR_INSTANCE_CODE VARCHAR2 (3)
VENDOR_NAME VARCHAR2 (80)
VENDOR_SITE_CODE VARCHAR2 (30)
SUPPLIER_SITE_CODE VARCHAR2 (30)
MESSAGE_ID NUMBER

PROCESS_FLAG NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ST_TRANSACTION_ID NUMBER

SCHEDULE_LINE_NUM VARCHAR2 (10)
ERROR_TEXT VARCHAR2 (2000)
OPERATION_SEQ_CODE VARCHAR2 (10)
BATCH_ID NUMBER

BILL_NAME VARCHAR2 (250)
ROUTING_NAME VARCHAR2 (250)
CURR_OP_SEQ_ID NUMBER

LINE_CODE VARCHAR2 (10)
EFFECTIVITY_DATE DATE

SHIP_FROM_PARTY_NAME VARCHAR2 (80)
SHIP_FROM_SITE_CODE VARCHAR2 (240)
END_ORDER_NUMBER VARCHAR2 (240)
END_ORDER_RELEASE_NUMBER VARCHAR2 (20)
END_ORDER_LINE_NUMBER VARCHAR2 (20)
ORDER_RELEASE_NUMBER VARCHAR2 (20)
COMMENTS VARCHAR2 (1000)
SHIP_TO_PARTY_NAME VARCHAR2 (80)
SHIP_TO_SITE_CODE VARCHAR2 (240)
PLANNING_PARTNER_SITE_ID NUMBER

PLANNING_TP_TYPE NUMBER

OWNING_PARTNER_SITE_ID NUMBER

OWNING_TP_TYPE NUMBER

VMI_FLAG VARCHAR2 (1)
NON_NETTABLE_QTY NUMBER

ORIGINAL_NEED_BY_DATE DATE

ORIGINAL_QUANTITY NUMBER

PROMISED_DATE DATE

NEED_BY_DATE DATE

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
END_ORDER_SHIPMENT_NUMBER NUMBER

POSTPROCESSING_LEAD_TIME NUMBER

WIP_START_QUANTITY NUMBER

ORDER_LINE_NUMBER VARCHAR2 (25)
UOM_CODE VARCHAR2 (25)
QUANTITY_PER_ASSEMBLY NUMBER

QUANTITY_ISSUED NUMBER

ACK_REFERENCE_NUMBER VARCHAR2 (200)
JOB_OP_SEQ_NUM NUMBER

JUMP_OP_SEQ_NUM NUMBER

JOB_OP_SEQ_CODE VARCHAR2 (10)
JUMP_OP_SEQ_CODE VARCHAR2 (10)
JUMP_OP_EFFECTIVITY_DATE DATE

SOURCE_ORG_ID NUMBER

SOURCE_INVENTORY_ITEM_ID NUMBER

SOURCE_VENDOR_ID NUMBER

SOURCE_VENDOR_SITE_ID NUMBER

SOURCE_TASK_ID NUMBER

SOURCE_PROJECT_ID NUMBER

SOURCE_FROM_ORGANIZATION_ID NUMBER

SOURCE_SR_MTL_SUPPLY_ID NUMBER

SOURCE_DISPOSITION_ID NUMBER

SOURCE_BILL_SEQUENCE_ID NUMBER

SOURCE_ROUTING_SEQUENCE_ID NUMBER

SOURCE_SCHEDULE_GROUP_ID NUMBER

SOURCE_WIP_ENTITY_ID NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

REQUESTED_START_DATE DATE

REQUESTED_COMPLETION_DATE DATE

SCHEDULE_PRIORITY NUMBER

ASSET_SERIAL_NUMBER VARCHAR2 (30)
ASSET_ITEM_ID NUMBER

ASSET_ITEM_NAME VARCHAR2 (240)
PLANNING_PARTNER_SITE_CODE VARCHAR2 (240)
OWNING_PARTNER_SITE_CODE VARCHAR2 (240)
ACTUAL_START_DATE DATE

SCHEDULE_ORIGINATION_TYPE NUMBER

SR_CUSTOMER_ACCT_ID NUMBER

ITEM_TYPE_ID NUMBER

ITEM_TYPE_VALUE NUMBER

CUSTOMER_PRODUCT_ID NUMBER

RO_STATUS_CODE VARCHAR2 (30)
SR_REPAIR_GROUP_ID NUMBER

SR_REPAIR_TYPE_ID NUMBER

RO_CREATION_DATE DATE

REPAIR_LEAD_TIME NUMBER

REQ_LINE_ID NUMBER

INTRANSIT_OWNING_ORG_ID NUMBER

CONDITION_TYPE VARCHAR2 (240)
REPAIR_NUMBER VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
MAINTENANCE_OBJECT_SOURCE NUMBER

PRODUCES_TO_STOCK NUMBER

ACTIVITY_TYPE VARCHAR2 (30)
CLASS_CODE VARCHAR2 (10)
SHUTDOWN_TYPE NUMBER

TO_BE_EXPLODED NUMBER

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

VISIT_ID NUMBER

ASSET_NUMBER VARCHAR2 (30)
MAINTENANCE_OBJECT_ID NUMBER

MAINTENANCE_OBJECT_TYPE NUMBER

OPERATING_FLEET NUMBER

MAINTENANCE_REQUIREMENT VARCHAR2 (30)
PRODUCT_CLASSIFICATION VARCHAR2 (150)
COLL_ORDER_TYPE NUMBER

Query Text

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


SELECT PLAN_ID
,      TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SCHEDULE_DESIGNATOR_ID
,      SOURCE_SCHEDULE_NAME
,      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
,      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_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
,      SOURCE
,      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
,      SOURCE_SUPPLY_SCHEDULE_NAME
,      NEW_SHIP_DATE
,      NEW_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
,      SCHEDULE_GROUP_NAME
,      BUILD_SEQUENCE
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      WO_LATENESS_COST
,      IMPLEMENT_PROCESSING_DAYS
,      DELIVERY_PRICE
,      LATE_SUPPLY_DATE
,      LATE_SUPPLY_QTY
,      SUBINVENTORY_CODE
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      SCHEDULE_DESIGNATOR
,      VENDOR_ID
,      VENDOR_SITE_ID
,      SUPPLIER_SITE_ID
,      PURCH_ORDER_ID
,      EXPECTED_SCRAP_QTY
,      QTY_SCRAPPED
,      QTY_COMPLETED
,      LOT_NUMBER
,      EXPIRATION_DATE
,      WIP_STATUS_CODE
,      DAILY_RATE
,      LOCATOR_ID
,      SERIAL_NUMBER
,      REFRESH_ID
,      LOCATOR_NAME
,      ONHAND_SOURCE_TYPE
,      SR_MTL_SUPPLY_ID
,      DEMAND_CLASS
,      FROM_ORGANIZATION_ID
,      WIP_SUPPLY_TYPE
,      PO_LINE_ID
,      BILL_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      COPRODUCTS_SUPPLY
,      CFM_ROUTING_FLAG
,      COMPANY_ID
,      COMPANY_NAME
,      ITEM_NAME
,      ORGANIZATION_CODE
,      FROM_ORGANIZATION_CODE
,      SUPPLIER_NAME
,      SOURCE_SR_INSTANCE_CODE
,      SOURCE_SUPPLIER_SITE_CODE
,      SOURCE_SUPPLIER_NAME
,      PROJECT_NUMBER
,      TASK_NUMBER
,      SR_INSTANCE_CODE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      SUPPLIER_SITE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      SCHEDULE_LINE_NUM
,      ERROR_TEXT
,      OPERATION_SEQ_CODE
,      BATCH_ID
,      BILL_NAME
,      ROUTING_NAME
,      CURR_OP_SEQ_ID
,      LINE_CODE
,      EFFECTIVITY_DATE
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_SITE_CODE
,      END_ORDER_NUMBER
,      END_ORDER_RELEASE_NUMBER
,      END_ORDER_LINE_NUMBER
,      ORDER_RELEASE_NUMBER
,      COMMENTS
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_SITE_CODE
,      PLANNING_PARTNER_SITE_ID
,      PLANNING_TP_TYPE
,      OWNING_PARTNER_SITE_ID
,      OWNING_TP_TYPE
,      VMI_FLAG
,      NON_NETTABLE_QTY
,      ORIGINAL_NEED_BY_DATE
,      ORIGINAL_QUANTITY
,      PROMISED_DATE
,      NEED_BY_DATE
,      ACCEPTANCE_REQUIRED_FLAG
,      END_ORDER_SHIPMENT_NUMBER
,      POSTPROCESSING_LEAD_TIME
,      WIP_START_QUANTITY
,      ORDER_LINE_NUMBER
,      UOM_CODE
,      QUANTITY_PER_ASSEMBLY
,      QUANTITY_ISSUED
,      ACK_REFERENCE_NUMBER
,      JOB_OP_SEQ_NUM
,      JUMP_OP_SEQ_NUM
,      JOB_OP_SEQ_CODE
,      JUMP_OP_SEQ_CODE
,      JUMP_OP_EFFECTIVITY_DATE
,      SOURCE_ORG_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_TASK_ID
,      SOURCE_PROJECT_ID
,      SOURCE_FROM_ORGANIZATION_ID
,      SOURCE_SR_MTL_SUPPLY_ID
,      SOURCE_DISPOSITION_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_ROUTING_SEQUENCE_ID
,      SOURCE_SCHEDULE_GROUP_ID
,      SOURCE_WIP_ENTITY_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      REQUESTED_START_DATE
,      REQUESTED_COMPLETION_DATE
,      SCHEDULE_PRIORITY
,      ASSET_SERIAL_NUMBER
,      ASSET_ITEM_ID
,      ASSET_ITEM_NAME
,      PLANNING_PARTNER_SITE_CODE
,      OWNING_PARTNER_SITE_CODE
,      ACTUAL_START_DATE
,      SCHEDULE_ORIGINATION_TYPE
,      SR_CUSTOMER_ACCT_ID
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      CUSTOMER_PRODUCT_ID
,      RO_STATUS_CODE
,      SR_REPAIR_GROUP_ID
,      SR_REPAIR_TYPE_ID
,      RO_CREATION_DATE
,      REPAIR_LEAD_TIME
,      REQ_LINE_ID
,      INTRANSIT_OWNING_ORG_ID
,      CONDITION_TYPE
,      REPAIR_NUMBER
,      DESCRIPTION
,      MAINTENANCE_OBJECT_SOURCE
,      PRODUCES_TO_STOCK
,      ACTIVITY_TYPE
,      CLASS_CODE
,      SHUTDOWN_TYPE
,      TO_BE_EXPLODED
,      OBJECT_TYPE
,      MAINTENANCE_TYPE_CODE
,      ACTIVITY_ITEM_ID
,      VISIT_ID
,      ASSET_NUMBER
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      OPERATING_FLEET
,      MAINTENANCE_REQUIREMENT
,      PRODUCT_CLASSIFICATION
,      COLL_ORDER_TYPE
FROM MSC.MSC_ST_SUPPLIES#;

Dependencies

[top of page]

MSC.MSC_ST_SUPPLIES# references the following:

SchemaMSC
TableMSC_ST_SUPPLIES
MSC.MSC_ST_SUPPLIES# is referenced by following:

SchemaAPPS
SynonymMSC_ST_SUPPLIES