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_CREDIT_CHECKLISTS_UV

Object Details

Object Name:	OKL_CREDIT_CHECKLISTS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CREDIT_CHECKLISTS_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 checklist
RGP_ID	NUMBER			Rule group identifier
KHR_ID	NUMBER			Contract header identifier
TODO_ITEM_CODE	VARCHAR2	(450)		To-do item code
TODO_ITEM_MEANING	VARCHAR2	(80)	Yes	To-do item meaning
MANDATORY_FLAG	VARCHAR2	(450)		Mandatory flag
MANDATORY_FLAG_MEANING	VARCHAR2	(80)	Yes	Mandatory flag meaning
CHECK_OFF	VARCHAR2	(450)		Checked off code
CHECK_OFF_MEANING	VARCHAR2	(80)	Yes	Checked off meaning
CHECK_OFF_RESULTS	VARCHAR2	(80)	Yes
NOTE	VARCHAR2	(450)		Note
STATUS	VARCHAR2	(450)		Status code
STATUS_MEANING	VARCHAR2	(90)	Yes	Status meaning
APPROVERYN	VARCHAR2	(4000)		Approver flag
ADMIN_NOTE	VARCHAR2	(450)
FUNCTION_VALIDATE_RSTS	VARCHAR2	(450)
FUNC_VAL_RSTS_MEANING	VARCHAR2	(80)	Yes
FUNCTION_VALIDATE_MSG	VARCHAR2	(450)
FUNCTION_ID	VARCHAR2	(450)
FUNCTION_NAME	VARCHAR2	(150)
FUNCTION_SOURCE	VARCHAR2	(720)
CHECKLIST_TYPE	VARCHAR2	(450)
CHECKLIST_TYPE_MEANING	VARCHAR2	(80)	Yes
CHECKIST_RESULTS	VARCHAR2	(80)

Query Text

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


SELECT ID
,      RGP_ID
,      KHR_ID
,      TODO_ITEM_CODE
,      TODO_ITEM_MEANING
,      MANDATORY_FLAG
,      MANDATORY_FLAG_MEANING
,      CHECK_OFF
,      CHECK_OFF_MEANING
,      CHECK_OFF_RESULTS
,      NOTE
,      STATUS
,      STATUS_MEANING
,      APPROVERYN
,      ADMIN_NOTE
,      FUNCTION_VALIDATE_RSTS
,      FUNC_VAL_RSTS_MEANING
,      FUNCTION_VALIDATE_MSG
,      FUNCTION_ID
,      FUNCTION_NAME
,      FUNCTION_SOURCE
,      CHECKLIST_TYPE
,      CHECKLIST_TYPE_MEANING
,      CHECKIST_RESULTS
FROM APPS.OKL_CREDIT_CHECKLISTS_UV;

Dependencies

[top of page]

APPS.OKL_CREDIT_CHECKLISTS_UV references the following:

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

APPS.OKL_CREDIT_CHECKLISTS_UV is referenced by following:

APPS: OKL_CREDIT_CHECKLIST_PVT - show dependent code; OKL_CREDIT_LINE_WF - show dependent code; OKL_CREDIT_PUB - show dependent code; OKL_FUNDING_CRD_CHECKLISTS_UV