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

VIEW: APPS.OKL_BPD_BATCH_LINES_UV

Object Details
Object Name: OKL_BPD_BATCH_LINES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_BATCH_LINES_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
BTC_ID NUMBER
Yes Foreign key to view OKL_TRX_CSH_BATCH_V
BTC_NAME VARCHAR2 (150) Yes
BTC_STATUS VARCHAR2 (30) Yes
ID NUMBER
Yes Primary key column
IRM_ID NUMBER

CONSOLIDATED_INVOICE_ID NUMBER

CONSOLIDATED_INVOICE_NUMBER VARCHAR2 (90)
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
CHECK_NUMBER VARCHAR2 (90)
Receipt Identifier
RECEIPT_DATE DATE

Date payment becomes effective
RCPT_STATUS_CODE VARCHAR2 (30)
AMOUNT NUMBER (14)
Amount
ILE_ID NUMBER

KHR_ID NUMBER

Foreign key to view OKL_K_HEADERS_V
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
CUSTOMER_NUMBER VARCHAR2 (30) Yes
Query Text

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


SELECT BTC_ID
,      BTC_NAME
,      BTC_STATUS
,      ID
,      IRM_ID
,      CONSOLIDATED_INVOICE_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      CURRENCY_CODE
,      CHECK_NUMBER
,      RECEIPT_DATE
,      RCPT_STATUS_CODE
,      AMOUNT
,      ILE_ID
,      KHR_ID
,      CONTRACT_NUMBER
,      CUSTOMER_NUMBER
FROM APPS.OKL_BPD_BATCH_LINES_UV;

Dependencies

[top of page]

APPS.OKL_BPD_BATCH_LINES_UV references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymOKC_K_HEADERS_B
SynonymOKL_CNSLD_AR_HDRS_ALL_B
ViewOKL_TRX_CSH_BATCH_V
SynonymOKL_TRX_CSH_RCPT_ALL_B
SynonymOKL_TXL_RCPT_APPS_ALL_B

APPS.OKL_BPD_BATCH_LINES_UV is not referenced by any database object