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.

[Home] [Help]

View: OKL_AM_CONTRACT_ADV_SEARCH_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_CONTRACT_ADV_SEARCH_UV

View Text

SELECT NULL CHR_ID
, NULL ASSET_NUMBER
, NULL SERIAL_NUMBER
, NULL CONTRACT_NUMBER
, NULL START_DATE
, NULL END_DATE
, NULL STS_CODE
, NULL STS_MEANING
, NULL AUTHORING_ORG_ID
, NULL PARTY_NAME
FROM OKL_AM_CONTRACT_PARTIES_UV OCP
WHERE OCP.ID = 0

Columns

Name
CHR_ID
ASSET_NUMBER
SERIAL_NUMBER
CONTRACT_NUMBER
START_DATE
END_DATE
STS_CODE
STS_MEANING
AUTHORING_ORG_ID
PARTY_NAME