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

VIEW: MSC.MSC_ST_SALES_ORDERS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

DEMAND_ID NUMBER

PRIMARY_UOM_QUANTITY NUMBER

RESERVATION_TYPE NUMBER

RESERVATION_QUANTITY NUMBER

DEMAND_SOURCE_TYPE NUMBER

DEMAND_SOURCE_HEADER_ID NUMBER

COMPLETED_QUANTITY NUMBER

SUBINVENTORY VARCHAR2 (10)
DEMAND_CLASS VARCHAR2 (34)
REQUIREMENT_DATE DATE

DEMAND_SOURCE_LINE VARCHAR2 (40)
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
DEMAND_SOURCE_NAME VARCHAR2 (30)
PARENT_DEMAND_ID NUMBER

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

REFRESH_ID NUMBER

SR_INSTANCE_ID NUMBER

SALES_ORDER_NUMBER VARCHAR2 (122)
SALESREP_CONTACT VARCHAR2 (100)
ORDERED_ITEM_ID NUMBER

AVAILABLE_TO_MRP VARCHAR2 (1)
CUSTOMER_ID NUMBER

SHIP_TO_SITE_USE_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

LINE_NUM NUMBER

TERRITORY_ID NUMBER

UPDATE_SEQ_NUM NUMBER

DEMAND_TYPE NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

PLANNING_GROUP VARCHAR2 (30)
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
DEMAND_PRIORITY NUMBER

ATP_REFRESH_NUMBER NUMBER

REQUEST_DATE DATE

SELLING_PRICE NUMBER

DEMAND_VISIBLE VARCHAR2 (1)
FORECAST_VISIBLE VARCHAR2 (1)
CTO_FLAG NUMBER

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
COMPANY_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
ITEM_NAME VARCHAR2 (250)
ORDERED_ITEM_NAME VARCHAR2 (250)
CUSTOMER_NAME VARCHAR2 (255)
SHIP_TO_SITE_CODE VARCHAR2 (30)
BILL_TO_SITE_CODE VARCHAR2 (30)
ORGANIZATION_CODE VARCHAR2 (7)
SR_INSTANCE_CODE VARCHAR2 (3)
PROJECT_NUMBER VARCHAR2 (25)
TASK_NUMBER VARCHAR2 (25)
MESSAGE_ID NUMBER

PROCESS_FLAG NUMBER

BATCH_ID NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ST_TRANSACTION_ID NUMBER

ERROR_TEXT VARCHAR2 (2000)
COMMENTS VARCHAR2 (1000)
ORDER_RELEASE_NUMBER VARCHAR2 (20)
END_ORDER_NUMBER VARCHAR2 (240)
END_ORDER_RELEASE_NUMBER VARCHAR2 (20)
END_ORDER_LINE_NUMBER VARCHAR2 (20)
END_ORDER_TYPE VARCHAR2 (240)
NEW_ORDER_PLACEMENT_DATE DATE

ORIGINAL_ITEM_ID NUMBER

PROMISE_DATE DATE

ORIGINAL_ITEM_NAME VARCHAR2 (250)
LINK_TO_LINE_ID NUMBER

CUST_PO_NUMBER VARCHAR2 (50)
CUSTOMER_LINE_NUMBER VARCHAR2 (50)
MFG_LEAD_TIME NUMBER

ORDER_DATE_TYPE_CODE NUMBER

LATEST_ACCEPTABLE_DATE DATE

SHIPPING_METHOD_CODE VARCHAR2 (30)
SCHEDULE_ARRIVAL_DATE DATE

ORG_FIRM_FLAG NUMBER

SHIP_SET_ID NUMBER

ARRIVAL_SET_ID NUMBER

SOURCE_DEMAND_SOURCE_HEADER_ID NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORIGINAL_ITEM_ID NUMBER

SOURCE_DEMAND_ID NUMBER

SOURCE_INVENTORY_ITEM_ID NUMBER

SOURCE_CUSTOMER_ID NUMBER

SOURCE_BILL_TO_SITE_USE_ID NUMBER

SOURCE_SHIP_TO_SITE_USE_ID NUMBER

ATO_LINE_ID NUMBER

SHIP_SET_NAME VARCHAR2 (30)
ARRIVAL_SET_NAME VARCHAR2 (30)
SALESREP_ID NUMBER

INTRANSIT_LEAD_TIME NUMBER

SOURCE_DEMAND_SOURCE_LINE VARCHAR2 (40)
ROW_TYPE NUMBER

REVISED_DMD_DATE DATE

REVISED_DMD_PRIORITY NUMBER

ITEM_TYPE_ID NUMBER

ITEM_TYPE_VALUE NUMBER

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      DEMAND_ID
,      PRIMARY_UOM_QUANTITY
,      RESERVATION_TYPE
,      RESERVATION_QUANTITY
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_HEADER_ID
,      COMPLETED_QUANTITY
,      SUBINVENTORY
,      DEMAND_CLASS
,      REQUIREMENT_DATE
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_NAME
,      PARENT_DEMAND_ID
,      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
,      REFRESH_ID
,      SR_INSTANCE_ID
,      SALES_ORDER_NUMBER
,      SALESREP_CONTACT
,      ORDERED_ITEM_ID
,      AVAILABLE_TO_MRP
,      CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      LINE_NUM
,      TERRITORY_ID
,      UPDATE_SEQ_NUM
,      DEMAND_TYPE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      END_ITEM_UNIT_NUMBER
,      DEMAND_PRIORITY
,      ATP_REFRESH_NUMBER
,      REQUEST_DATE
,      SELLING_PRICE
,      DEMAND_VISIBLE
,      FORECAST_VISIBLE
,      CTO_FLAG
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      COMPANY_ID
,      COMPANY_NAME
,      ITEM_NAME
,      ORDERED_ITEM_NAME
,      CUSTOMER_NAME
,      SHIP_TO_SITE_CODE
,      BILL_TO_SITE_CODE
,      ORGANIZATION_CODE
,      SR_INSTANCE_CODE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      MESSAGE_ID
,      PROCESS_FLAG
,      BATCH_ID
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      COMMENTS
,      ORDER_RELEASE_NUMBER
,      END_ORDER_NUMBER
,      END_ORDER_RELEASE_NUMBER
,      END_ORDER_LINE_NUMBER
,      END_ORDER_TYPE
,      NEW_ORDER_PLACEMENT_DATE
,      ORIGINAL_ITEM_ID
,      PROMISE_DATE
,      ORIGINAL_ITEM_NAME
,      LINK_TO_LINE_ID
,      CUST_PO_NUMBER
,      CUSTOMER_LINE_NUMBER
,      MFG_LEAD_TIME
,      ORDER_DATE_TYPE_CODE
,      LATEST_ACCEPTABLE_DATE
,      SHIPPING_METHOD_CODE
,      SCHEDULE_ARRIVAL_DATE
,      ORG_FIRM_FLAG
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      SOURCE_DEMAND_SOURCE_HEADER_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORIGINAL_ITEM_ID
,      SOURCE_DEMAND_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_CUSTOMER_ID
,      SOURCE_BILL_TO_SITE_USE_ID
,      SOURCE_SHIP_TO_SITE_USE_ID
,      ATO_LINE_ID
,      SHIP_SET_NAME
,      ARRIVAL_SET_NAME
,      SALESREP_ID
,      INTRANSIT_LEAD_TIME
,      SOURCE_DEMAND_SOURCE_LINE
,      ROW_TYPE
,      REVISED_DMD_DATE
,      REVISED_DMD_PRIORITY
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
FROM MSC.MSC_ST_SALES_ORDERS#;

Dependencies

[top of page]

MSC.MSC_ST_SALES_ORDERS# references the following:

SchemaMSC
TableMSC_ST_SALES_ORDERS
MSC.MSC_ST_SALES_ORDERS# is referenced by following:

SchemaAPPS
SynonymMSC_ST_SALES_ORDERS