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: ViewOKL.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

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:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymJTF_RS_TEAMS_TL
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOKC_K_HEADERS_B
SynonymOKL_ASSET_RETURNS_ALL_B
ViewOKL_K_LINES_FULL_V
APPS.OKL_AM_ASSET_SALE_UV is referenced by following:

SchemaAPPS
Package BodyOKL_AM_ASSET_RETURN_PVT - show dependent code