DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_BPD_BTCH_CONT_SUMRY_UV

Object Details
Object Name: OKL_BPD_BTCH_CONT_SUMRY_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_BTCH_CONT_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 Mandatory Comments
ID NUMBER
Yes Primary key column
NAME VARCHAR2 (150) Yes Name
BATCH_QTY NUMBER (15)
Number of invoices with payments applied
BATCH_TOTAL VARCHAR2 (18)
monetary amount
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
DATE_DEPOSIT DATE

Date of receipt deposit into account
DATE_GL_REQUESTED DATE

GL processing date
TRX_STATUS_CODE VARCHAR2 (30) Yes 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

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
FROM APPS.OKL_BPD_BTCH_CONT_SUMRY_UV;

Dependencies

[top of page]

APPS.OKL_BPD_BTCH_CONT_SUMRY_UV references the following:

SchemaAPPS
ViewOKL_TRX_CSH_BATCH_V
ViewOKL_TRX_CSH_RECEIPT_V
ViewOKL_TXL_RCPT_APPS_V

APPS.OKL_BPD_BTCH_CONT_SUMRY_UV is not referenced by any database object