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_BTCH_SUMRY_UV

Object Details

Object Name:	OKL_BPD_BTCH_SUMRY_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_BPD_BTCH_SUMRY_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	Comments
ID	NUMBER		Primary key column
NAME	VARCHAR2	(150)	Name
BATCH_QTY	NUMBER	(15)	Number of invoices with payments applied
BATCH_TOTAL	NUMBER	(14)	monetary amount
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
DATE_DEPOSIT	DATE		Date of receipt deposit into account
DATE_GL_REQUESTED	DATE		GL processing date
TRX_STATUS_CODE	VARCHAR2	(30)	Transaction Status
IRM_ID	NUMBER
ORG_ID	NUMBER	(15)	Operating Unit identifier
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_DATE	DATE
RECEIPT_METHOD	VARCHAR2	(30)
CNR_ID	NUMBER
CONSOLIDATED_INVOICE_NUMBER	VARCHAR2	(90)
BATCH_STATUS	VARCHAR2	(80)
CHR_ID	NUMBER
CONTRACT_NUMBER	VARCHAR2	(120)
UPDATE_STATUS	VARCHAR2	(14)
REMOVE_STATUS	VARCHAR2	(14)
TYPE	CHAR	(4)

Query Text

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


SELECT ID
,      NAME
,      BATCH_QTY
,      BATCH_TOTAL
,      CURRENCY_CODE
,      DATE_DEPOSIT
,      DATE_GL_REQUESTED
,      TRX_STATUS_CODE
,      IRM_ID
,      ORG_ID
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      RECEIPT_METHOD
,      CNR_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      BATCH_STATUS
,      CHR_ID
,      CONTRACT_NUMBER
,      UPDATE_STATUS
,      REMOVE_STATUS
,      TYPE
FROM APPS.OKL_BPD_BTCH_SUMRY_UV;

Dependencies

[top of page]

APPS.OKL_BPD_BTCH_SUMRY_UV references the following:

APPS: AR_RECEIPT_METHODS; FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_K_HEADERS_B; OKL_CNSLD_AR_HDRS_B; OKL_TRX_CSH_BATCH_V; OKL_TRX_CSH_RECEIPT_V; OKL_TXL_RCPT_APPS_V

APPS.OKL_BPD_BTCH_SUMRY_UV is not referenced by any database object