VIEW: MSC.MSC_SUPDEM_LINES_INTERFACE#

Source

View Text - Preformatted

select PARENT_HEADER_ID PARENT_HEADER_ID, LINE_ID LINE_ID, QUANTITY QUANTITY, UOM UOM, START_DATE START_DATE, END_DATE END_DATE, ITEM_NAME ITEM_NAME, PUBLISHER_SITE_ID PUBLISHER_SITE_ID, SUBSCRIBERS_XREF_NAME SUBSCRIBERS_XREF_NAME, BUCKET_TYPE BUCKET_TYPE, ORDER_IDENTIFIER ORDER_IDENTIFIER, PEGGING_ORDER_IDENTIFIER PEGGING_ORDER_IDENTIFIER, LINE_NUMBER LINE_NUMBER, ROW_STATUS ROW_STATUS, ERR_MSG ERR_MSG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORDER_TYPE ORDER_TYPE, COMMENTS COMMENTS, NEW_DOCK_DATE NEW_DOCK_DATE, NEW_SHIP_DATE NEW_SHIP_DATE, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE, RELEASE_NUMBER RELEASE_NUMBER, REF_LINE_NUMBER REF_LINE_NUMBER, REF_RELEASE_NUMBER REF_RELEASE_NUMBER, PUBLISHER_ADDRESS PUBLISHER_ADDRESS, SUBSCRIBER_ADDRESS SUBSCRIBER_ADDRESS, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME, SHIP_TO_PARTY_ADDRESS SHIP_TO_PARTY_ADDRESS, SHIP_TO_ADDRESS SHIP_TO_ADDRESS, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME, SHIP_FROM_PARTY_ADDRESS SHIP_FROM_PARTY_ADDRESS, CARRIER_CODE CARRIER_CODE, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER, TRACKING_NUMBER TRACKING_NUMBER, VEHICLE_NUMBER VEHICLE_NUMBER, CONTAINER_TYPE CONTAINER_TYPE, CONTAINER_QTY CONTAINER_QTY, END_ORDER_PUBLISHER_NAME END_ORDER_PUBLISHER_NAME, END_ORDER_TYPE END_ORDER_TYPE, REF_HEADER_ID REF_HEADER_ID, REF_LINE_ID REF_LINE_ID, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, NEW_SCHEDULE_END_DATE NEW_SCHEDULE_END_DATE, PUBLISHER_COMPANY PUBLISHER_COMPANY, PUBLISHER_SITE PUBLISHER_SITE, CUSTOMER_COMPANY CUSTOMER_COMPANY, CUSTOMER_SITE CUSTOMER_SITE, SUPPLIER_COMPANY SUPPLIER_COMPANY, SUPPLIER_SITE SUPPLIER_SITE, CUSTOMER_ADDRESS CUSTOMER_ADDRESS, SUPPLIER_ADDRESS SUPPLIER_ADDRESS, SHIP_TO_PARTY_SITE SHIP_TO_PARTY_SITE, SHIP_FROM_PARTY_SITE SHIP_FROM_PARTY_SITE, SHIP_DATE SHIP_DATE, RECEIPT_DATE RECEIPT_DATE, REQUEST_ID REQUEST_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, 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, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTACHMENT_URL ATTACHMENT_URL, SERIAL_NUMBER SERIAL_NUMBER, SYNC_INDICATOR SYNC_INDICATOR, POSTING_PARTY_NAME POSTING_PARTY_NAME, END_ORDER_PUBLISHER_SITE END_ORDER_PUBLISHER_SITE, KEY_DATE KEY_DATE, REQUEST_DATE REQUEST_DATE, KEY_END_DATE KEY_END_DATE, ORIGINAL_PROMISED_DATE ORIGINAL_PROMISED_DATE, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME, OWNER_ITEM_NAME OWNER_ITEM_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, VERSION VERSION, DESIGNATOR DESIGNATOR, CONTEXT CONTEXT, WIP_START_DATE WIP_START_DATE, WIP_END_DATE WIP_END_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, RESPONSE_NUMBER RESPONSE_NUMBER, VMI_FLAG VMI_FLAG, SHIPPING_CONTROL SHIPPING_CONTROL, DEMAND_CLASS DEMAND_CLASS from "MSC"."MSC_SUPDEM_LINES_INTERFACE"

View Text - HTML Formatted

SELECT PARENT_HEADER_ID PARENT_HEADER_ID
, LINE_ID LINE_ID
, QUANTITY QUANTITY
, UOM UOM
, START_DATE START_DATE
, END_DATE END_DATE
, ITEM_NAME ITEM_NAME
, PUBLISHER_SITE_ID PUBLISHER_SITE_ID
, SUBSCRIBERS_XREF_NAME SUBSCRIBERS_XREF_NAME
, BUCKET_TYPE BUCKET_TYPE
, ORDER_IDENTIFIER ORDER_IDENTIFIER
, PEGGING_ORDER_IDENTIFIER PEGGING_ORDER_IDENTIFIER
, LINE_NUMBER LINE_NUMBER
, ROW_STATUS ROW_STATUS
, ERR_MSG ERR_MSG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORDER_TYPE ORDER_TYPE
, COMMENTS COMMENTS
, NEW_DOCK_DATE NEW_DOCK_DATE
, NEW_SHIP_DATE NEW_SHIP_DATE
, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE
, RELEASE_NUMBER RELEASE_NUMBER
, REF_LINE_NUMBER REF_LINE_NUMBER
, REF_RELEASE_NUMBER REF_RELEASE_NUMBER
, PUBLISHER_ADDRESS PUBLISHER_ADDRESS
, SUBSCRIBER_ADDRESS SUBSCRIBER_ADDRESS
, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME
, SHIP_TO_PARTY_ADDRESS SHIP_TO_PARTY_ADDRESS
, SHIP_TO_ADDRESS SHIP_TO_ADDRESS
, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME
, SHIP_FROM_PARTY_ADDRESS SHIP_FROM_PARTY_ADDRESS
, CARRIER_CODE CARRIER_CODE
, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER
, TRACKING_NUMBER TRACKING_NUMBER
, VEHICLE_NUMBER VEHICLE_NUMBER
, CONTAINER_TYPE CONTAINER_TYPE
, CONTAINER_QTY CONTAINER_QTY
, END_ORDER_PUBLISHER_NAME END_ORDER_PUBLISHER_NAME
, END_ORDER_TYPE END_ORDER_TYPE
, REF_HEADER_ID REF_HEADER_ID
, REF_LINE_ID REF_LINE_ID
, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, NEW_SCHEDULE_END_DATE NEW_SCHEDULE_END_DATE
, PUBLISHER_COMPANY PUBLISHER_COMPANY
, PUBLISHER_SITE PUBLISHER_SITE
, CUSTOMER_COMPANY CUSTOMER_COMPANY
, CUSTOMER_SITE CUSTOMER_SITE
, SUPPLIER_COMPANY SUPPLIER_COMPANY
, SUPPLIER_SITE SUPPLIER_SITE
, CUSTOMER_ADDRESS CUSTOMER_ADDRESS
, SUPPLIER_ADDRESS SUPPLIER_ADDRESS
, SHIP_TO_PARTY_SITE SHIP_TO_PARTY_SITE
, SHIP_FROM_PARTY_SITE SHIP_FROM_PARTY_SITE
, SHIP_DATE SHIP_DATE
, RECEIPT_DATE RECEIPT_DATE
, REQUEST_ID REQUEST_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, 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
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTACHMENT_URL ATTACHMENT_URL
, SERIAL_NUMBER SERIAL_NUMBER
, SYNC_INDICATOR SYNC_INDICATOR
, POSTING_PARTY_NAME POSTING_PARTY_NAME
, END_ORDER_PUBLISHER_SITE END_ORDER_PUBLISHER_SITE
, KEY_DATE KEY_DATE
, REQUEST_DATE REQUEST_DATE
, KEY_END_DATE KEY_END_DATE
, ORIGINAL_PROMISED_DATE ORIGINAL_PROMISED_DATE
, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, OWNER_ITEM_NAME OWNER_ITEM_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, VERSION VERSION
, DESIGNATOR DESIGNATOR
, CONTEXT CONTEXT
, WIP_START_DATE WIP_START_DATE
, WIP_END_DATE WIP_END_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, RESPONSE_NUMBER RESPONSE_NUMBER
, VMI_FLAG VMI_FLAG
, SHIPPING_CONTROL SHIPPING_CONTROL
, DEMAND_CLASS DEMAND_CLASS
FROM "MSC"."MSC_SUPDEM_LINES_INTERFACE"