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

VIEW: APPS.OKL_LA_TNA_REQUEST_UV

Object Details
Object Name: OKL_LA_TNA_REQUEST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_TNA_REQUEST_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
NEW_CONTRACT_NUMBER VARCHAR2 (120)
New Contract Number
TNA_REQUEST_NUMBER VARCHAR2 (30) Yes Transfer and Assumption request number
TRX_ID NUMBER
Yes Transaction identifier
TRX_NUMBER VARCHAR2 (30) Yes Transaction Number
KHR_ID_OLD NUMBER

Contract identifier
TSU_CODE VARCHAR2 (30) Yes Code for transaction status
Query Text

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


SELECT NEW_CONTRACT_NUMBER
,      TNA_REQUEST_NUMBER
,      TRX_ID
,      TRX_NUMBER
,      KHR_ID_OLD
,      TSU_CODE
FROM APPS.OKL_LA_TNA_REQUEST_UV;

Dependencies

[top of page]

APPS.OKL_LA_TNA_REQUEST_UV references the following:

SchemaAPPS
SynonymOKL_TAA_REQUEST_DETAILS_B
SynonymOKL_TRX_CONTRACTS
SynonymOKL_TRX_TYPES_TL

APPS.OKL_LA_TNA_REQUEST_UV is not referenced by any database object