[Home] [Help] [Dependency Information]
Object Name: | MSC_SUPDEM_LINES_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_HEADER_ID | NUMBER | |||
LINE_ID | NUMBER | |||
QUANTITY | NUMBER | |||
UOM | VARCHAR2 | (30) | ||
START_DATE | VARCHAR2 | (40) | ||
END_DATE | VARCHAR2 | (40) | ||
ITEM_NAME | VARCHAR2 | (240) | ||
PUBLISHER_SITE_ID | VARCHAR2 | (20) | ||
SUBSCRIBERS_XREF_NAME | VARCHAR2 | (240) | ||
BUCKET_TYPE | VARCHAR2 | (20) | ||
ORDER_IDENTIFIER | VARCHAR2 | (240) | ||
PEGGING_ORDER_IDENTIFIER | VARCHAR2 | (240) | ||
LINE_NUMBER | VARCHAR2 | (25) | ||
ROW_STATUS | NUMBER | |||
ERR_MSG | VARCHAR2 | (1000) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ORDER_TYPE | VARCHAR2 | (240) | ||
COMMENTS | VARCHAR2 | (1000) | ||
NEW_DOCK_DATE | VARCHAR2 | (40) | ||
NEW_SHIP_DATE | VARCHAR2 | (40) | ||
NEW_ORDER_PLACEMENT_DATE | VARCHAR2 | (40) | ||
RELEASE_NUMBER | VARCHAR2 | (25) | ||
REF_LINE_NUMBER | VARCHAR2 | (25) | ||
REF_RELEASE_NUMBER | VARCHAR2 | (25) | ||
PUBLISHER_ADDRESS | VARCHAR2 | (240) | ||
SUBSCRIBER_ADDRESS | VARCHAR2 | (240) | ||
SHIP_TO_PARTY_NAME | VARCHAR2 | (255) | ||
SHIP_TO_PARTY_ADDRESS | VARCHAR2 | (240) | ||
SHIP_TO_ADDRESS | VARCHAR2 | (240) | ||
SHIP_FROM_PARTY_NAME | VARCHAR2 | (255) | ||
SHIP_FROM_PARTY_ADDRESS | VARCHAR2 | (240) | ||
CARRIER_CODE | VARCHAR2 | (30) | ||
BILL_OF_LADING_NUMBER | VARCHAR2 | (30) | ||
TRACKING_NUMBER | VARCHAR2 | (240) | ||
VEHICLE_NUMBER | VARCHAR2 | (30) | ||
CONTAINER_TYPE | VARCHAR2 | (20) | ||
CONTAINER_QTY | NUMBER | |||
END_ORDER_PUBLISHER_NAME | VARCHAR2 | (255) | ||
END_ORDER_TYPE | VARCHAR2 | (240) | ||
REF_HEADER_ID | NUMBER | |||
REF_LINE_ID | NUMBER | |||
NEW_SCHEDULE_DATE | VARCHAR2 | (40) | ||
NEW_SCHEDULE_END_DATE | VARCHAR2 | (40) | ||
PUBLISHER_COMPANY | VARCHAR2 | (255) | ||
PUBLISHER_SITE | VARCHAR2 | (40) | ||
CUSTOMER_COMPANY | VARCHAR2 | (255) | ||
CUSTOMER_SITE | VARCHAR2 | (40) | ||
SUPPLIER_COMPANY | VARCHAR2 | (255) | ||
SUPPLIER_SITE | VARCHAR2 | (40) | ||
CUSTOMER_ADDRESS | VARCHAR2 | (255) | ||
SUPPLIER_ADDRESS | VARCHAR2 | (255) | ||
SHIP_TO_PARTY_SITE | VARCHAR2 | (40) | ||
SHIP_FROM_PARTY_SITE | VARCHAR2 | (40) | ||
SHIP_DATE | VARCHAR2 | (255) | ||
RECEIPT_DATE | VARCHAR2 | (255) | ||
REQUEST_ID | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
PROGRAM_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
ATTACHMENT_URL | VARCHAR2 | (240) | ||
SERIAL_NUMBER | VARCHAR2 | (255) | ||
SYNC_INDICATOR | VARCHAR2 | (1) | ||
POSTING_PARTY_NAME | VARCHAR2 | (255) | ||
END_ORDER_PUBLISHER_SITE | VARCHAR2 | (40) | ||
KEY_DATE | VARCHAR2 | (40) | ||
REQUEST_DATE | VARCHAR2 | (240) | ||
KEY_END_DATE | VARCHAR2 | (40) | ||
ORIGINAL_PROMISED_DATE | VARCHAR2 | (40) | ||
CUSTOMER_ITEM_NAME | VARCHAR2 | (250) | ||
SUPPLIER_ITEM_NAME | VARCHAR2 | (250) | ||
OWNER_ITEM_NAME | VARCHAR2 | (250) | ||
INVENTORY_ITEM_ID | NUMBER | |||
VERSION | VARCHAR2 | (240) | ||
DESIGNATOR | VARCHAR2 | (100) | ||
CONTEXT | VARCHAR2 | (30) | ||
WIP_START_DATE | VARCHAR2 | (40) | ||
WIP_END_DATE | VARCHAR2 | (40) | ||
DOCUMENT_NUMBER | VARCHAR2 | (240) | ||
RESPONSE_NUMBER | VARCHAR2 | (240) | ||
VMI_FLAG | VARCHAR2 | (1) | ||
SHIPPING_CONTROL | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_HEADER_ID
, LINE_ID
, QUANTITY
, UOM
, START_DATE
, END_DATE
, ITEM_NAME
, PUBLISHER_SITE_ID
, SUBSCRIBERS_XREF_NAME
, BUCKET_TYPE
, ORDER_IDENTIFIER
, PEGGING_ORDER_IDENTIFIER
, LINE_NUMBER
, ROW_STATUS
, ERR_MSG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORDER_TYPE
, COMMENTS
, NEW_DOCK_DATE
, NEW_SHIP_DATE
, NEW_ORDER_PLACEMENT_DATE
, RELEASE_NUMBER
, REF_LINE_NUMBER
, REF_RELEASE_NUMBER
, PUBLISHER_ADDRESS
, SUBSCRIBER_ADDRESS
, SHIP_TO_PARTY_NAME
, SHIP_TO_PARTY_ADDRESS
, SHIP_TO_ADDRESS
, SHIP_FROM_PARTY_NAME
, SHIP_FROM_PARTY_ADDRESS
, CARRIER_CODE
, BILL_OF_LADING_NUMBER
, TRACKING_NUMBER
, VEHICLE_NUMBER
, CONTAINER_TYPE
, CONTAINER_QTY
, END_ORDER_PUBLISHER_NAME
, END_ORDER_TYPE
, REF_HEADER_ID
, REF_LINE_ID
, NEW_SCHEDULE_DATE
, NEW_SCHEDULE_END_DATE
, PUBLISHER_COMPANY
, PUBLISHER_SITE
, CUSTOMER_COMPANY
, CUSTOMER_SITE
, SUPPLIER_COMPANY
, SUPPLIER_SITE
, CUSTOMER_ADDRESS
, SUPPLIER_ADDRESS
, SHIP_TO_PARTY_SITE
, SHIP_FROM_PARTY_SITE
, SHIP_DATE
, RECEIPT_DATE
, REQUEST_ID
, SUBINVENTORY_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ATTACHMENT_URL
, SERIAL_NUMBER
, SYNC_INDICATOR
, POSTING_PARTY_NAME
, END_ORDER_PUBLISHER_SITE
, KEY_DATE
, REQUEST_DATE
, KEY_END_DATE
, ORIGINAL_PROMISED_DATE
, CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME
, OWNER_ITEM_NAME
, INVENTORY_ITEM_ID
, VERSION
, DESIGNATOR
, CONTEXT
, WIP_START_DATE
, WIP_END_DATE
, DOCUMENT_NUMBER
, RESPONSE_NUMBER
, VMI_FLAG
, SHIPPING_CONTROL
, DEMAND_CLASS
FROM MSC.MSC_SUPDEM_LINES_INTERFACE#;
|
|
|