[Home] [Help] [Dependency Information]
Object Name: | CS_ORDERS_INTERFACE_ALL# |
---|---|
Object Type: | VIEW |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_INTERFACE_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
TRANSACTION_CODE | VARCHAR2 | (30) | ||
LINE_ID | NUMBER | (15) | ||
HEADER_ID | NUMBER | (15) | ||
CONCURRENT_PROCESS_ID | NUMBER | (15) | ||
RETURN_CP_ID | NUMBER | (15) | ||
RETURN_QUANTITY | NUMBER | (15) | ||
CANCEL_CP_ID | NUMBER | (15) | ||
CANCEL_QUANTITY | NUMBER | (15) | ||
SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
CP_SERVICE_ID | NUMBER | (15) | ||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
SHIPPED_QUANTITY | NUMBER | (15) | ||
SHIPPED_DATE | DATE | |||
SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
PICKING_HEADER_ID | NUMBER | (15) | ||
DELIVERED_FLAG | VARCHAR2 | (1) | ||
MASS_RENEW_TXN_TEMP_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | |||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
LOT_NUMBER | VARCHAR2 | (30) | ||
REVISION | VARCHAR2 | (3) | ||
LINE_DETAIL_ID | NUMBER | |||
INCLUDED_ITEM_FLAG | VARCHAR2 | (1) | ||
ERROR_FLAG | VARCHAR2 | (1) | ||
SKIP_FLAG | VARCHAR2 | (1) | ||
ERROR_SKIP_REASON | VARCHAR2 | (250) |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_INTERFACE_ID
, CREATED_BY
, CREATION_DATE
, TRANSACTION_CODE
, LINE_ID
, HEADER_ID
, CONCURRENT_PROCESS_ID
, RETURN_CP_ID
, RETURN_QUANTITY
, CANCEL_CP_ID
, CANCEL_QUANTITY
, SERVICE_ITEM_FLAG
, CP_SERVICE_ID
, CUSTOMER_PRODUCT_ID
, SHIPPED_QUANTITY
, SHIPPED_DATE
, SHIP_TO_SITE_USE_ID
, PICKING_HEADER_ID
, DELIVERED_FLAG
, MASS_RENEW_TXN_TEMP_ID
, ORG_ID
, SERIAL_NUMBER
, LOT_NUMBER
, REVISION
, LINE_DETAIL_ID
, INCLUDED_ITEM_FLAG
, ERROR_FLAG
, SKIP_FLAG
, ERROR_SKIP_REASON
FROM CS.CS_ORDERS_INTERFACE_ALL#;
|
|
|