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

VIEW: APPS.OKL_RECEIPT_APPLICATIONS_UV

Object Details
Object Name: OKL_RECEIPT_APPLICATIONS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_RECEIPT_APPLICATIONS_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
CASH_RECEIPT_ID NUMBER (15)
Cash Receipt Id
RECEIPT_NUMBER VARCHAR2 (30)
Receipt Number
CUSTOMER_TRX_ID NUMBER (15)
Customer Transaction Id
INVOICE_NUMBER VARCHAR2 (150)
Invoice Number
LINE_TYPE VARCHAR2 (7)
Line Type
LINE_APPLIED NUMBER

Amount Applied on Invoice Line
TAX_APPLIED NUMBER

Amount Applied on the Tax of the invoice
LINE_BALANCE NUMBER

Amount balance on the invoice line
TAX_BALANCE NUMBER

Tax balance on the invoice
LINE_NUMBER NUMBER

Invoice Line Number
CUSTOMER_TRX_LINE_ID NUMBER

Customer Transaction Line Id
APPLY_DATE DATE

Receipt application date
INVOICE_DATE DATE

Invoice Transaction Date
DUE_DATE DATE

Invoice Due Date
ASSET_NUMBER VARCHAR2 (150)
Asset Number
STREAM_TYPE VARCHAR2 (150)
Stream Type
CONTRACT_NUMBER VARCHAR2 (150)
Contract Number
GL_DATE DATE

GL Date
TRANS_TO_RECEIPT_RATE NUMBER

Exchange Rate for the cash application
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Invoice Currency Code
RECEIVABLE_APPLICATION_ID NUMBER (15)
Receivable Application Id
LINE_TAX_APPLIED NUMBER

Amount Applied on the Tax of the invoice line
LINE_TAX_BALANCE NUMBER

Tax balance on the invoice line
Query Text

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


SELECT CASH_RECEIPT_ID
,      RECEIPT_NUMBER
,      CUSTOMER_TRX_ID
,      INVOICE_NUMBER
,      LINE_TYPE
,      LINE_APPLIED
,      TAX_APPLIED
,      LINE_BALANCE
,      TAX_BALANCE
,      LINE_NUMBER
,      CUSTOMER_TRX_LINE_ID
,      APPLY_DATE
,      INVOICE_DATE
,      DUE_DATE
,      ASSET_NUMBER
,      STREAM_TYPE
,      CONTRACT_NUMBER
,      GL_DATE
,      TRANS_TO_RECEIPT_RATE
,      INVOICE_CURRENCY_CODE
,      RECEIVABLE_APPLICATION_ID
,      LINE_TAX_APPLIED
,      LINE_TAX_BALANCE
FROM APPS.OKL_RECEIPT_APPLICATIONS_UV;

Dependencies

[top of page]

APPS.OKL_RECEIPT_APPLICATIONS_UV references the following:

SchemaAPPS
SynonymAR_ACTIVITY_DETAILS
SynonymAR_CASH_RECEIPTS_ALL
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymOKL_CNSLD_AR_LINES_B
SynonymOKL_CNSLD_AR_STRMS_B
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
APPS.OKL_RECEIPT_APPLICATIONS_UV is referenced by following:

SchemaAPPS
Package BodyOKL_BPD_ADVANCED_CASH_APP_PVT - show dependent code
Package BodyOKL_BPD_ADV_MON_RPT_PVT - show dependent code
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
PL/SQL PackageOKL_UPDT_CASH_DTLS - show dependent code