VIEW: MSC.MSC_SUP_DEM_ENTRIES#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, PUBLISHER_ID PUBLISHER_ID, PUBLISHER_SITE_ID PUBLISHER_SITE_ID, PUBLISHER_NAME PUBLISHER_NAME, PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, QUANTITY QUANTITY, TP_QUANTITY TP_QUANTITY, COMMENTS COMMENTS, PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, LINE_CODE LINE_CODE, BUCKET_TYPE BUCKET_TYPE, ORDER_NUMBER ORDER_NUMBER, END_ORDER_NUMBER END_ORDER_NUMBER, NEW_DOCK_DATE NEW_DOCK_DATE, POSTING_PARTY_ID POSTING_PARTY_ID, NEW_SHIP_DATE NEW_SHIP_DATE, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE, RELEASE_NUMBER RELEASE_NUMBER, LINE_NUMBER LINE_NUMBER, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, PUBLISHER_ADDRESS_ID PUBLISHER_ADDRESS_ID, CARRIER_CODE CARRIER_CODE, VEHICLE_NUMBER VEHICLE_NUMBER, CONTAINER_TYPE CONTAINER_TYPE, CONTAINER_QTY CONTAINER_QTY, TRACKING_NUMBER TRACKING_NUMBER, VERSION VERSION, END_ORDER_TYPE END_ORDER_TYPE, END_ORDER_PUBLISHER_ID END_ORDER_PUBLISHER_ID, SHIP_TO_ADDRESS SHIP_TO_ADDRESS, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_ADDRESS_ID SHIP_TO_PARTY_ADDRESS_ID, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME, SHIP_TO_PARTY_SITE_NAME SHIP_TO_PARTY_SITE_NAME, SHIP_FROM_PARTY_ADDRESS_ID SHIP_FROM_PARTY_ADDRESS_ID, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME, SHIP_FROM_PARTY_SITE_NAME SHIP_FROM_PARTY_SITE_NAME, OWNING_SITE_ID OWNING_SITE_ID, OWNING_SITE_NAME OWNING_SITE_NAME, END_ORDER_PUBLISHER_SITE_ID END_ORDER_PUBLISHER_SITE_ID, END_ORDER_PUBLISHER_SITE_NAME END_ORDER_PUBLISHER_SITE_NAME, END_ORDER_PUBLISHER_NAME END_ORDER_PUBLISHER_NAME, PUBLISHER_ITEM_NAME PUBLISHER_ITEM_NAME, TRADING_PARTNER_ITEM_NAME TRADING_PARTNER_ITEM_NAME, PUB_ITEM_DESCRIPTIION PUB_ITEM_DESCRIPTIION, TP_ITEM_DESCRIPTION TP_ITEM_DESCRIPTION, PUBLISHER_ORDER_TYPE_DESC PUBLISHER_ORDER_TYPE_DESC, TP_ORDER_TYPE_DESC TP_ORDER_TYPE_DESC, DESIGNATOR DESIGNATOR, CONTEXT CONTEXT, UNIT_NUMBER UNIT_NUMBER, SHIP_METHOD SHIP_METHOD, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, PLANNING_GROUP PLANNING_GROUP, SHIP_FROM_ADDRESS SHIP_FROM_ADDRESS, PUBLISHER_ADDRESS PUBLISHER_ADDRESS, CUSTOMER_ADDRESS CUSTOMER_ADDRESS, SUPPLIER_ADDRESS SUPPLIER_ADDRESS, AVERAGE_ANNUAL_DEMAND AVERAGE_ANNUAL_DEMAND, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER, BUCKET_TYPE_DESC BUCKET_TYPE_DESC, SERIAL_NUMBER SERIAL_NUMBER, RELEASE_STATUS RELEASE_STATUS, INVENTORY_STATUS INVENTORY_STATUS, WIP_END_DATE WIP_END_DATE, WIP_START_DATE WIP_START_DATE, PROMISE_SHIP_DATE PROMISE_SHIP_DATE, NEW_SCHEDULE_END_DATE NEW_SCHEDULE_END_DATE, POSTING_PARTY_NAME POSTING_PARTY_NAME, PUB_ITEM_DESCRIPTION PUB_ITEM_DESCRIPTION, UOM_CODE UOM_CODE, TP_UOM_CODE TP_UOM_CODE, PLANNER_CODE PLANNER_CODE, LAST_REFRESH_NUMBER LAST_REFRESH_NUMBER, ATTACHMENT_URL ATTACHMENT_URL, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, KEY_DATE KEY_DATE, SHIP_DATE SHIP_DATE, RECEIPT_DATE RECEIPT_DATE, ORIGINAL_PROMISED_DATE ORIGINAL_PROMISED_DATE, REQUEST_DATE REQUEST_DATE, PRIMARY_UOM PRIMARY_UOM, PRIMARY_QUANTITY PRIMARY_QUANTITY, REF_HEADER_ID REF_HEADER_ID, REF_LINE_ID REF_LINE_ID, CATEGORY_NAME CATEGORY_NAME, PUBLISHER_ORG_ID PUBLISHER_ORG_ID, SUBSCRIBER_ORG_ID SUBSCRIBER_ORG_ID, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, CATEGORY_ID CATEGORY_ID, START_DATE START_DATE, END_DATE END_DATE, PRODUCTION_SEQUENCE PRODUCTION_SEQUENCE, SEQ_PLAN_COMPLETION_FLAG SEQ_PLAN_COMPLETION_FLAG, INPUT_PLAN_ID INPUT_PLAN_ID, END_ASSEMBLY_ITEM_NAME END_ASSEMBLY_ITEM_NAME, SUBSCRIBER_ADDRESS_ID SUBSCRIBER_ADDRESS_ID, TP_ORDER_TYPE TP_ORDER_TYPE, PROCESSED_FLAG PROCESSED_FLAG, PLANNED_WIP_START_DATE PLANNED_WIP_START_DATE, PLANNED_WIP_END_DATE PLANNED_WIP_END_DATE, SUBINVENTORY_CODE SUBINVENTORY_CODE, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME, OWNER_ITEM_NAME OWNER_ITEM_NAME, ITEM_NAME ITEM_NAME, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY, ITEM_DESCRIPTION ITEM_DESCRIPTION, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION, SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESCRIPTION, OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESCRIPTION, TOTAL_QUANTITY TOTAL_QUANTITY, TOTAL_PRIMARY_QUANTITY TOTAL_PRIMARY_QUANTITY, TOTAL_TP_QUANTITY TOTAL_TP_QUANTITY, NUMBER1 NUMBER1, VMI_FLAG VMI_FLAG, ACK_FLAG ACK_FLAG, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, DOCUMENT_NUMBER DOCUMENT_NUMBER, RESPONSE_NUMBER RESPONSE_NUMBER, NEED_BY_DATE NEED_BY_DATE, PROMISED_DATE PROMISED_DATE, BASE_ITEM_ID BASE_ITEM_ID, BASE_ITEM_NAME BASE_ITEM_NAME, SHIPPING_CONTROL SHIPPING_CONTROL, LINK_TRANS_ID LINK_TRANS_ID, INTERNAL_FLAG INTERNAL_FLAG, SOURCE_DELIVERY_ID SOURCE_DELIVERY_ID, SR_DELIVERY_STATUS_CODE SR_DELIVERY_STATUS_CODE, SHIPPING_CONTROL_CODE SHIPPING_CONTROL_CODE, END_ORDER_TYPE_DESC END_ORDER_TYPE_DESC, DEMAND_CLASS DEMAND_CLASS from "MSC"."MSC_SUP_DEM_ENTRIES"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, PUBLISHER_ID PUBLISHER_ID
, PUBLISHER_SITE_ID PUBLISHER_SITE_ID
, PUBLISHER_NAME PUBLISHER_NAME
, PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME
, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QUANTITY QUANTITY
, TP_QUANTITY TP_QUANTITY
, COMMENTS COMMENTS
, PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, LINE_CODE LINE_CODE
, BUCKET_TYPE BUCKET_TYPE
, ORDER_NUMBER ORDER_NUMBER
, END_ORDER_NUMBER END_ORDER_NUMBER
, NEW_DOCK_DATE NEW_DOCK_DATE
, POSTING_PARTY_ID POSTING_PARTY_ID
, NEW_SHIP_DATE NEW_SHIP_DATE
, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE
, RELEASE_NUMBER RELEASE_NUMBER
, LINE_NUMBER LINE_NUMBER
, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, PUBLISHER_ADDRESS_ID PUBLISHER_ADDRESS_ID
, CARRIER_CODE CARRIER_CODE
, VEHICLE_NUMBER VEHICLE_NUMBER
, CONTAINER_TYPE CONTAINER_TYPE
, CONTAINER_QTY CONTAINER_QTY
, TRACKING_NUMBER TRACKING_NUMBER
, VERSION VERSION
, END_ORDER_TYPE END_ORDER_TYPE
, END_ORDER_PUBLISHER_ID END_ORDER_PUBLISHER_ID
, SHIP_TO_ADDRESS SHIP_TO_ADDRESS
, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_ADDRESS_ID SHIP_TO_PARTY_ADDRESS_ID
, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME
, SHIP_TO_PARTY_SITE_NAME SHIP_TO_PARTY_SITE_NAME
, SHIP_FROM_PARTY_ADDRESS_ID SHIP_FROM_PARTY_ADDRESS_ID
, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME
, SHIP_FROM_PARTY_SITE_NAME SHIP_FROM_PARTY_SITE_NAME
, OWNING_SITE_ID OWNING_SITE_ID
, OWNING_SITE_NAME OWNING_SITE_NAME
, END_ORDER_PUBLISHER_SITE_ID END_ORDER_PUBLISHER_SITE_ID
, END_ORDER_PUBLISHER_SITE_NAME END_ORDER_PUBLISHER_SITE_NAME
, END_ORDER_PUBLISHER_NAME END_ORDER_PUBLISHER_NAME
, PUBLISHER_ITEM_NAME PUBLISHER_ITEM_NAME
, TRADING_PARTNER_ITEM_NAME TRADING_PARTNER_ITEM_NAME
, PUB_ITEM_DESCRIPTIION PUB_ITEM_DESCRIPTIION
, TP_ITEM_DESCRIPTION TP_ITEM_DESCRIPTION
, PUBLISHER_ORDER_TYPE_DESC PUBLISHER_ORDER_TYPE_DESC
, TP_ORDER_TYPE_DESC TP_ORDER_TYPE_DESC
, DESIGNATOR DESIGNATOR
, CONTEXT CONTEXT
, UNIT_NUMBER UNIT_NUMBER
, SHIP_METHOD SHIP_METHOD
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, PLANNING_GROUP PLANNING_GROUP
, SHIP_FROM_ADDRESS SHIP_FROM_ADDRESS
, PUBLISHER_ADDRESS PUBLISHER_ADDRESS
, CUSTOMER_ADDRESS CUSTOMER_ADDRESS
, SUPPLIER_ADDRESS SUPPLIER_ADDRESS
, AVERAGE_ANNUAL_DEMAND AVERAGE_ANNUAL_DEMAND
, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER
, BUCKET_TYPE_DESC BUCKET_TYPE_DESC
, SERIAL_NUMBER SERIAL_NUMBER
, RELEASE_STATUS RELEASE_STATUS
, INVENTORY_STATUS INVENTORY_STATUS
, WIP_END_DATE WIP_END_DATE
, WIP_START_DATE WIP_START_DATE
, PROMISE_SHIP_DATE PROMISE_SHIP_DATE
, NEW_SCHEDULE_END_DATE NEW_SCHEDULE_END_DATE
, POSTING_PARTY_NAME POSTING_PARTY_NAME
, PUB_ITEM_DESCRIPTION PUB_ITEM_DESCRIPTION
, UOM_CODE UOM_CODE
, TP_UOM_CODE TP_UOM_CODE
, PLANNER_CODE PLANNER_CODE
, LAST_REFRESH_NUMBER LAST_REFRESH_NUMBER
, ATTACHMENT_URL ATTACHMENT_URL
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, KEY_DATE KEY_DATE
, SHIP_DATE SHIP_DATE
, RECEIPT_DATE RECEIPT_DATE
, ORIGINAL_PROMISED_DATE ORIGINAL_PROMISED_DATE
, REQUEST_DATE REQUEST_DATE
, PRIMARY_UOM PRIMARY_UOM
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, REF_HEADER_ID REF_HEADER_ID
, REF_LINE_ID REF_LINE_ID
, CATEGORY_NAME CATEGORY_NAME
, PUBLISHER_ORG_ID PUBLISHER_ORG_ID
, SUBSCRIBER_ORG_ID SUBSCRIBER_ORG_ID
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, CATEGORY_ID CATEGORY_ID
, START_DATE START_DATE
, END_DATE END_DATE
, PRODUCTION_SEQUENCE PRODUCTION_SEQUENCE
, SEQ_PLAN_COMPLETION_FLAG SEQ_PLAN_COMPLETION_FLAG
, INPUT_PLAN_ID INPUT_PLAN_ID
, END_ASSEMBLY_ITEM_NAME END_ASSEMBLY_ITEM_NAME
, SUBSCRIBER_ADDRESS_ID SUBSCRIBER_ADDRESS_ID
, TP_ORDER_TYPE TP_ORDER_TYPE
, PROCESSED_FLAG PROCESSED_FLAG
, PLANNED_WIP_START_DATE PLANNED_WIP_START_DATE
, PLANNED_WIP_END_DATE PLANNED_WIP_END_DATE
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, OWNER_ITEM_NAME OWNER_ITEM_NAME
, ITEM_NAME ITEM_NAME
, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS
, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION
, SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESCRIPTION
, OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESCRIPTION
, TOTAL_QUANTITY TOTAL_QUANTITY
, TOTAL_PRIMARY_QUANTITY TOTAL_PRIMARY_QUANTITY
, TOTAL_TP_QUANTITY TOTAL_TP_QUANTITY
, NUMBER1 NUMBER1
, VMI_FLAG VMI_FLAG
, ACK_FLAG ACK_FLAG
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, RESPONSE_NUMBER RESPONSE_NUMBER
, NEED_BY_DATE NEED_BY_DATE
, PROMISED_DATE PROMISED_DATE
, BASE_ITEM_ID BASE_ITEM_ID
, BASE_ITEM_NAME BASE_ITEM_NAME
, SHIPPING_CONTROL SHIPPING_CONTROL
, LINK_TRANS_ID LINK_TRANS_ID
, INTERNAL_FLAG INTERNAL_FLAG
, SOURCE_DELIVERY_ID SOURCE_DELIVERY_ID
, SR_DELIVERY_STATUS_CODE SR_DELIVERY_STATUS_CODE
, SHIPPING_CONTROL_CODE SHIPPING_CONTROL_CODE
, END_ORDER_TYPE_DESC END_ORDER_TYPE_DESC
, DEMAND_CLASS DEMAND_CLASS
FROM "MSC"."MSC_SUP_DEM_ENTRIES"