[Home] [Help] [Dependency Information]
Object Name: | OKL_AM_ASSET_SALE_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AM_ASSET_SALE_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ART_ID | NUMBER | Yes | Foreign key to view OKL_ASSET_RETURNS_V | |
KLE_ID | NUMBER | Yes | Foreign key to view OKL_K_LINES_V | |
ORDER_NUMBER | NUMBER | Yes | User-visible number of the order | |
ORDERED_DATE | DATE | Ordered Date | ||
LINE_NUMBER | NUMBER | Yes | Line Number | |
HEADER_ID | NUMBER | Yes | Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs. | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item ID | |
ITEM_NAME | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
CUSTOMER_ID | NUMBER | Customer to whom the item is sold to | ||
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Name of this party |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
UNIT_SELLING_PRICE | NUMBER | Actual price chaged to customer | ||
UNIT_LIST_PRICE | NUMBER | Price List price for the item | ||
TAX_VALUE | NUMBER | The Tax amount in order currency | ||
ACTUAL_SHIPMENT_DATE | DATE | Actual Shipment Date of the line | ||
ORDERED_QUANTITY | NUMBER | Quantity Ordered | ||
BOOKED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether order line is booked (Y) or not (N) |
SHIP_SITE_ID | NUMBER | Ship to Organization Id | ||
SHIP_TO_CONTACT_ID | NUMBER | Person to which line is to be shipped | ||
SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | Yes | First line for address |
SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
SHIP_TO_CITY | VARCHAR2 | (60) | City | |
SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
SHIP_TO_STATE | VARCHAR2 | (60) | State | |
SHIP_TO_PROVINCE | VARCHAR2 | (60) | Province | |
SHIP_TO_COUNTY | VARCHAR2 | (60) | County | |
SHIP_TO_COUNTRY | VARCHAR2 | (60) | Yes | Country code from the TERRITORY_CODE column in the FND_TERRITORY table |
SHIP_TO_FULL_ADDRESS | VARCHAR2 | (80) | ||
ASSET_NUMBER | VARCHAR2 | (150) | Asset Number | |
ASSET_DESCRIPTION | VARCHAR2 | (1995) | Item description. | |
STATUS | VARCHAR2 | (30) | Yes | Status |
FA_COST | NUMBER | |||
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
ORDER_STATUS | VARCHAR2 | (30) | Workflow status for the header | |
RMR_ID | NUMBER | |||
ITEM_CATALOG_GROUP_ID | NUMBER | |||
REMARKETER_NAME | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | Operating Unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ART_ID
, KLE_ID
, ORDER_NUMBER
, ORDERED_DATE
, LINE_NUMBER
, HEADER_ID
, INVENTORY_ITEM_ID
, ITEM_NAME
, ITEM_DESCRIPTION
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, UNIT_SELLING_PRICE
, UNIT_LIST_PRICE
, TAX_VALUE
, ACTUAL_SHIPMENT_DATE
, ORDERED_QUANTITY
, BOOKED_FLAG
, SHIP_SITE_ID
, SHIP_TO_CONTACT_ID
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_STATE
, SHIP_TO_PROVINCE
, SHIP_TO_COUNTY
, SHIP_TO_COUNTRY
, SHIP_TO_FULL_ADDRESS
, ASSET_NUMBER
, ASSET_DESCRIPTION
, STATUS
, FA_COST
, CONTRACT_NUMBER
, ORDER_STATUS
, RMR_ID
, ITEM_CATALOG_GROUP_ID
, REMARKETER_NAME
, ORG_ID
FROM APPS.OKL_AM_ASSET_SALE_UV;
|
|
|