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_K_HDR_CRDTLN_UV

Object Details

Object Name:	OKL_K_HDR_CRDTLN_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_K_HDR_CRDTLN_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
ID	NUMBER		Yes	Unique identifier for credit line
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	User defined unique credit line number
SHORT_DESCRIPTION	VARCHAR2	(600)		User entered short description of credt line
DESCRIPTION	VARCHAR2	(1995)		Description of credt line
SCS_CODE	VARCHAR2	(30)	Yes	Subcalss code for credt line contracts
CURRENCY_CODE	VARCHAR2	(15)		Currency code
STS_CODE	VARCHAR2	(30)	Yes	Credit line status code
TEMPLATE_YN	VARCHAR2	(3)	Yes	Indicates whether credit line is a template
BUY_OR_SELL	VARCHAR2	(3)		Indicates contract intent
START_DATE	DATE			Credit line start date
END_DATE	DATE			Credit line end date
REVOLVING_CREDIT_YN	VARCHAR2	(3)		Indicates whether revolving credit
CUST_OBJECT1_ID1	VARCHAR2	(40)		Credt line party identifier
CUST_OBJECT1_ID2	VARCHAR2	(200)		Credit line party identifier
CUST_JTOT_OBJECT1_CODE	VARCHAR2	(30)		Credit line party source code
CUST_NAME	VARCHAR2	(360)	Yes	Cedit line party name
CUST_ACC_NUMBER	VARCHAR2	(30)	Yes	Credit line customer account number

Query Text

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


SELECT ID
,      CONTRACT_NUMBER
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      SCS_CODE
,      CURRENCY_CODE
,      STS_CODE
,      TEMPLATE_YN
,      BUY_OR_SELL
,      START_DATE
,      END_DATE
,      REVOLVING_CREDIT_YN
,      CUST_OBJECT1_ID1
,      CUST_OBJECT1_ID2
,      CUST_JTOT_OBJECT1_CODE
,      CUST_NAME
,      CUST_ACC_NUMBER
FROM APPS.OKL_K_HDR_CRDTLN_UV;

Dependencies

[top of page]

APPS.OKL_K_HDR_CRDTLN_UV references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES; OKC_K_HEADERS_B; OKC_K_HEADERS_TL; OKC_K_PARTY_ROLES_B; OKL_K_HEADERS

APPS.OKL_K_HDR_CRDTLN_UV is referenced by following:

APPS: OKL_DEAL_CREATE_PUB - show dependent code; OKL_DEAL_CREAT_PVT - show dependent code; OKL_LA_VALIDATION_UTIL_PVT - show dependent code; OKL_RELEASE_PVT - show dependent code