[Home] [Help] [Dependency Information]
Object Name: | WSH_REPORT_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | OE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_TEMP_ID | NUMBER | |||
DEPARTURE_ID | NUMBER | |||
DELIVERY_ID | NUMBER | |||
LINE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
ITEM_CATEGORIES | NUMBER | |||
ITEM_INDENTATION | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
CUSTOMER_ITEM_ID | NUMBER | |||
COMPONENT_RATIO | NUMBER | |||
COMPONENT_CODE | VARCHAR2 | (1000) | ||
COMPONENT_SEQUENCE_ID | NUMBER | |||
PURCHASE_ORDER_NUM | VARCHAR2 | (50) | ||
ORDER_NUMBER | NUMBER | |||
SHIP_TO_CONTACT_ID | NUMBER | |||
SELLING_PRICE | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (3) | ||
CURRENCY_CODE | VARCHAR2 | (3) | ||
QUANTITY_TO_INVOICE | NUMBER | |||
SHIPPED_QUANTITY | NUMBER | |||
TOTAL_SHIPPED_TODATE | NUMBER | |||
TOTAL_ALREADY_SHIPPED | NUMBER | |||
ORDERED_QUANTITY | NUMBER | |||
SHIPPED_FLAG | VARCHAR2 | (1) | ||
CHILD_RFR_FLAG | VARCHAR2 | (1) | ||
REQUIRED_FOR_REVENUE_FLAG | VARCHAR2 | (1) | ||
CONFIGURATION_ITEM_FLAG | VARCHAR2 | (1) | ||
INCLUDE_ON_SHIP_DOCS | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_TEMP_ID
, DEPARTURE_ID
, DELIVERY_ID
, LINE_ID
, ORGANIZATION_ID
, ITEM_CATEGORIES
, ITEM_INDENTATION
, INVENTORY_ITEM_ID
, CUSTOMER_ITEM_ID
, COMPONENT_RATIO
, COMPONENT_CODE
, COMPONENT_SEQUENCE_ID
, PURCHASE_ORDER_NUM
, ORDER_NUMBER
, SHIP_TO_CONTACT_ID
, SELLING_PRICE
, UNIT_OF_MEASURE
, CURRENCY_CODE
, QUANTITY_TO_INVOICE
, SHIPPED_QUANTITY
, TOTAL_SHIPPED_TODATE
, TOTAL_ALREADY_SHIPPED
, ORDERED_QUANTITY
, SHIPPED_FLAG
, CHILD_RFR_FLAG
, REQUIRED_FOR_REVENUE_FLAG
, CONFIGURATION_ITEM_FLAG
, INCLUDE_ON_SHIP_DOCS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM OE.WSH_REPORT_TEMP#;
|
|
|