[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_SALES_ORDERS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|