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_CRD_FUND_CHECKLISTS_TPL_UV

Object Details

Object Name:	OKL_CRD_FUND_CHECKLISTS_TPL_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CRD_FUND_CHECKLISTS_TPL_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
RGP_ID	NUMBER			Rule group identifier
KHR_ID	NUMBER			Contract header identifier
LACLFM_ID	VARCHAR2	(40)		Rule identifier
TODO_ITEM_CODE	VARCHAR2	(450)		Checklist item to-do code
TODO_ITEM_MEANING	VARCHAR2	(80)	Yes	Checklist item to-do meaning
MANDATORY_FLAG	VARCHAR2	(450)		Mandatory flag code
MANDATORY_FLAG_MEANING	VARCHAR2	(80)	Yes	Mandatory flag meaning
NOTE	VARCHAR2	(450)		Note
STATUS	VARCHAR2	(450)		Status code
STATUS_MEANING	VARCHAR2	(90)	Yes	Status meaning
EFFECTIVE_FROM	DATE			Effective from
EFFECTIVE_TO	DATE			Effective to
APPROVERYN	VARCHAR2	(4000)		Aprrover flag
ADMIN_NOTE	VARCHAR2	(450)
FUNCTION_ID	VARCHAR2	(450)
FUNCTION_NAME	VARCHAR2	(150)
FUNCTION_SOURCE	VARCHAR2	(720)
CHECKLIST_TYPE	VARCHAR2	(450)
CHECKLIST_TYPE_MEANING	VARCHAR2	(80)	Yes

Query Text

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


SELECT ID
,      RGP_ID
,      KHR_ID
,      LACLFM_ID
,      TODO_ITEM_CODE
,      TODO_ITEM_MEANING
,      MANDATORY_FLAG
,      MANDATORY_FLAG_MEANING
,      NOTE
,      STATUS
,      STATUS_MEANING
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      APPROVERYN
,      ADMIN_NOTE
,      FUNCTION_ID
,      FUNCTION_NAME
,      FUNCTION_SOURCE
,      CHECKLIST_TYPE
,      CHECKLIST_TYPE_MEANING
FROM APPS.OKL_CRD_FUND_CHECKLISTS_TPL_UV;

Dependencies

[top of page]

APPS.OKL_CRD_FUND_CHECKLISTS_TPL_UV references the following:

APPS: FND_DATE - show dependent code; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_PROFILE - show dependent code; OKC_RULES_B; OKC_STATUSES_V; OKL_DATA_SRC_FNCTNS_V

APPS.OKL_CRD_FUND_CHECKLISTS_TPL_UV is referenced by following:

APPS: OKL_CREDIT_CHECKLIST_PVT - show dependent code; OKL_FUNDING_PVT - show dependent code