VIEW: MSC.MSC_ST_SALES_ORDERS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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