eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKL_AM_ASSET_SALE_UV

Object Details

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

View Type

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.

[View Source]

Columns

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	(14)
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

Query Text

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;

Dependencies

[top of page]

APPS.OKL_AM_ASSET_SALE_UV references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; JTF_RS_TEAMS_TL; MTL_SYSTEM_ITEMS_B_KFV; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OKC_K_HEADERS_B; OKL_ASSET_RETURNS_ALL_B; OKL_K_LINES_FULL_V

APPS.OKL_AM_ASSET_SALE_UV is referenced by following:

APPS: OKL_AM_ASSET_RETURN_PVT - show dependent code