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_RMK_BILLING_UV

Object Details

Object Name:	OKL_AM_RMK_BILLING_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_RMK_BILLING_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
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID
ASSET_NUMBER	VARCHAR2	(150)		Asset Number
ASSET_DESCRIPTION	VARCHAR2	(1995)		Item description.
STATUS	VARCHAR2	(30)	Yes	Status
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
ITEM_NUMBER	VARCHAR2	(40)
INVOICE_NUMBER	VARCHAR2	(150)
INVOICE_AMOUNT	NUMBER	(14)	Yes
INVOICE_DATE	DATE		Yes
BILL_DATE	DATE		Yes
BILL_TO_ADDRESS1	VARCHAR2	(240)	Yes
BILL_TO_ADDRESS2	VARCHAR2	(240)
BILL_TO_ADDRESS3	VARCHAR2	(240)
BILL_TO_ADDRESS4	VARCHAR2	(240)
BILL_TO_CITY	VARCHAR2	(60)
BILL_TO_POSTAL_CODE	VARCHAR2	(60)
BILL_TO_STATE	VARCHAR2	(60)
BILL_TO_PROVINCE	VARCHAR2	(60)
BILL_TO_COUNTY	VARCHAR2	(60)
BILL_TO_COUNTRY	VARCHAR2	(60)	Yes
BILL_TO_FULL_ADDRESS	VARCHAR2	(80)
ITEM_NAME	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
TAX_AMOUNT	NUMBER
ORIGINAL_INVOICE_AMOUNT	NUMBER		Yes	Amount
LSM_ID	NUMBER		Yes	Primary key column of OKL_CNSLD_AR_STRMS_B
TOTAL_INVOICE_AMOUNT	NUMBER	(14)	Yes	Total Invoice Amount
STY_ID	NUMBER			Foreign key to table OKL_STRM_TYPE_B
OUTSTANDING_INVOICE_AMOUNT	NUMBER			Remaining line amount of the item
TRX_ID	NUMBER	(15)	Yes
TRX_LINE_ID	NUMBER	(15)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ART_ID
,      KLE_ID
,      ORDER_NUMBER
,      ORDERED_DATE
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      STATUS
,      CONTRACT_NUMBER
,      ITEM_NUMBER
,      INVOICE_NUMBER
,      INVOICE_AMOUNT
,      INVOICE_DATE
,      BILL_DATE
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_POSTAL_CODE
,      BILL_TO_STATE
,      BILL_TO_PROVINCE
,      BILL_TO_COUNTY
,      BILL_TO_COUNTRY
,      BILL_TO_FULL_ADDRESS
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      TAX_AMOUNT
,      ORIGINAL_INVOICE_AMOUNT
,      LSM_ID
,      TOTAL_INVOICE_AMOUNT
,      STY_ID
,      OUTSTANDING_INVOICE_AMOUNT
,      TRX_ID
,      TRX_LINE_ID
FROM APPS.OKL_AM_RMK_BILLING_UV;

Dependencies

[top of page]

APPS.OKL_AM_RMK_BILLING_UV references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; AR_PAYMENT_SCHEDULES_ALL; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTY_SITES; MTL_SYSTEM_ITEMS_B_KFV; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OKC_K_HEADERS_B; OKL_ASSET_RETURNS_ALL_B; OKL_BILLING_UTIL_PVT - show dependent code; OKL_BPD_TLD_AR_LINES_V; OKL_K_LINES_FULL_V

APPS.OKL_AM_RMK_BILLING_UV is not referenced by any database object