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_BPD_VAR_INT_PROCESS_UV

Object Details

Object Name:	OKL_BPD_VAR_INT_PROCESS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_BPD_VAR_INT_PROCESS_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
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
REQUEST_ID	NUMBER	(15)		Concurrent Program Request Number
CONTRACT_STATUS	VARCHAR2	(30)	Yes	Contract Status
PARENT_TRANSACTION_NUMBER	NUMBER		Yes	Transaction Number of the Original Super Trump request
PARENT_SIF_ID	NUMBER		Yes	ID of the Original Super Trump request
PARENT_SIS_CODE	VARCHAR2	(30)	Yes	Status Code of the Original Super Trump request
PARENT_STATUS	VARCHAR2	(4000)		Status Description of the Original Super Trump request
PARENT_ORP_CODE	VARCHAR2	(30)	Yes	Process Originating the Original Super Trump request
PARENT_ORIGINATING_PROCESS	VARCHAR2	(4000)		Description of the Process Originating the Original Super Trump request
PARENT_DATE_PROCESSED	DATE		Yes	Processing Date of the Original Super Trump request
PARENT_LOG_FILE	VARCHAR2	(200)		Log File of the Original Super Trump request
CHILD_TRANSACTION_NUMBER	NUMBER			Transaction NUmber of the Childl Super Trump request
CHILD_SIF_ID	NUMBER			ID of the Child Super Trump request
CHILD_SIS_CODE	VARCHAR2	(30)		Status Code of the Child Super Trump request
CHILD_STATUS	VARCHAR2	(4000)		Status Description of the Child Super Trump request
CHILD_ORP_CODE	VARCHAR2	(30)		Originating Transaction Code of the Child Super Trump request
CHILD_ORIGINATING_PROCESS	VARCHAR2	(4000)		Originating Transaction Description of the Child Super Trump request
CHILD_DATE_PROCESSED	DATE			Processed Date of the Child Super Trump request
CHILD_LOG_FILE	VARCHAR2	(200)		Log File of the Child Super Trump request
ORG_ID	NUMBER		Yes	Operating Unit
CONTRACT_ID	NUMBER		Yes	Contract Id

Query Text

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


SELECT CONTRACT_NUMBER
,      REQUEST_ID
,      CONTRACT_STATUS
,      PARENT_TRANSACTION_NUMBER
,      PARENT_SIF_ID
,      PARENT_SIS_CODE
,      PARENT_STATUS
,      PARENT_ORP_CODE
,      PARENT_ORIGINATING_PROCESS
,      PARENT_DATE_PROCESSED
,      PARENT_LOG_FILE
,      CHILD_TRANSACTION_NUMBER
,      CHILD_SIF_ID
,      CHILD_SIS_CODE
,      CHILD_STATUS
,      CHILD_ORP_CODE
,      CHILD_ORIGINATING_PROCESS
,      CHILD_DATE_PROCESSED
,      CHILD_LOG_FILE
,      ORG_ID
,      CONTRACT_ID
FROM APPS.OKL_BPD_VAR_INT_PROCESS_UV;

Dependencies

[top of page]

APPS.OKL_BPD_VAR_INT_PROCESS_UV references the following:

APPS: OKC_K_HEADERS_B; OKL_ACCOUNTING_UTIL - show dependent code; OKL_STREAM_INTERFACES; OKL_VAR_INT_PROCESS_B

APPS.OKL_BPD_VAR_INT_PROCESS_UV is not referenced by any database object