VIEW: MSC.MSC_SALES_ORDERS#

Source

View Text - Preformatted

select DEMAND_ID DEMAND_ID, SR_INSTANCE_ID SR_INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME, PRIMARY_UOM_QUANTITY PRIMARY_UOM_QUANTITY, RESERVATION_TYPE RESERVATION_TYPE, RESERVATION_QUANTITY RESERVATION_QUANTITY, COMPLETED_QUANTITY COMPLETED_QUANTITY, REQUIREMENT_DATE REQUIREMENT_DATE, SUBINVENTORY SUBINVENTORY, DEMAND_CLASS DEMAND_CLASS, PARENT_DEMAND_ID PARENT_DEMAND_ID, REFRESH_NUMBER REFRESH_NUMBER, 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, 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, SUPPLY_ID SUPPLY_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, OLD_PRIMARY_UOM_QUANTITY OLD_PRIMARY_UOM_QUANTITY, OLD_RESERVATION_QUANTITY OLD_RESERVATION_QUANTITY, OLD_COMPLETED_QUANTITY OLD_COMPLETED_QUANTITY, OLD_REQUIREMENT_DATE OLD_REQUIREMENT_DATE, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID, PROMISE_DATE PROMISE_DATE, LINK_TO_LINE_ID LINK_TO_LINE_ID, PARENT_ID PARENT_ID, CUST_PO_NUMBER CUST_PO_NUMBER, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER, SR_DEMAND_ID SR_DEMAND_ID, RECORD_SOURCE RECORD_SOURCE, MFG_LEAD_TIME MFG_LEAD_TIME, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, ORG_FIRM_FLAG ORG_FIRM_FLAG, ATP_OVERRIDE_FLAG ATP_OVERRIDE_FLAG, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_SET_ID SHIP_SET_ID, ARRIVAL_SET_ID ARRIVAL_SET_ID, ATO_LINE_ID ATO_LINE_ID, ARRIVAL_SET_NAME ARRIVAL_SET_NAME, SHIP_SET_NAME SHIP_SET_NAME, REQUEST_SHIP_DATE REQUEST_SHIP_DATE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, SALESREP_ID SALESREP_ID, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, SR_CUSTOMER_ACCT_ID SR_CUSTOMER_ACCT_ID, PREV_COLL_ITEM_ID PREV_COLL_ITEM_ID, ROW_TYPE ROW_TYPE, SR_SO_LINEID SR_SO_LINEID, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS, 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_SALES_ORDERS"

View Text - HTML Formatted

SELECT DEMAND_ID DEMAND_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME
, PRIMARY_UOM_QUANTITY PRIMARY_UOM_QUANTITY
, RESERVATION_TYPE RESERVATION_TYPE
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, COMPLETED_QUANTITY COMPLETED_QUANTITY
, REQUIREMENT_DATE REQUIREMENT_DATE
, SUBINVENTORY SUBINVENTORY
, DEMAND_CLASS DEMAND_CLASS
, PARENT_DEMAND_ID PARENT_DEMAND_ID
, REFRESH_NUMBER REFRESH_NUMBER
, 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
, 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
, SUPPLY_ID SUPPLY_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, OLD_PRIMARY_UOM_QUANTITY OLD_PRIMARY_UOM_QUANTITY
, OLD_RESERVATION_QUANTITY OLD_RESERVATION_QUANTITY
, OLD_COMPLETED_QUANTITY OLD_COMPLETED_QUANTITY
, OLD_REQUIREMENT_DATE OLD_REQUIREMENT_DATE
, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID
, PROMISE_DATE PROMISE_DATE
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, PARENT_ID PARENT_ID
, CUST_PO_NUMBER CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER
, SR_DEMAND_ID SR_DEMAND_ID
, RECORD_SOURCE RECORD_SOURCE
, MFG_LEAD_TIME MFG_LEAD_TIME
, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, ORG_FIRM_FLAG ORG_FIRM_FLAG
, ATP_OVERRIDE_FLAG ATP_OVERRIDE_FLAG
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_SET_ID SHIP_SET_ID
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, ATO_LINE_ID ATO_LINE_ID
, ARRIVAL_SET_NAME ARRIVAL_SET_NAME
, SHIP_SET_NAME SHIP_SET_NAME
, REQUEST_SHIP_DATE REQUEST_SHIP_DATE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, SALESREP_ID SALESREP_ID
, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME
, SR_CUSTOMER_ACCT_ID SR_CUSTOMER_ACCT_ID
, PREV_COLL_ITEM_ID PREV_COLL_ITEM_ID
, ROW_TYPE ROW_TYPE
, SR_SO_LINEID SR_SO_LINEID
, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS
, 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_SALES_ORDERS"