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

VIEW: APPS.OKL_CS_INV_RECEIPTS_UV

Object Details
Object Name: OKL_CS_INV_RECEIPTS_UV
Object Type: VIEW
Owner: APPS
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
INVOICE_NUMBER VARCHAR2 (150)
AR/Consolidated Invoice Number
RECEIPT_NUMBER VARCHAR2 (30)
Receipt Number
RECEIPT_DATE DATE

Receipt Date
RECEIPT_STATUS VARCHAR2 (80)
Receipt Status
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
Receipt Currency code
RECEIPT_AMOUNT NUMBER

Receipt Amount
AMOUNT_APPLIED NUMBER

Amount Applied
RECEIPT_TYPE_CODE VARCHAR2 (3)
Receipt Type
PAYMENT_METHOD VARCHAR2 (30)
Receipt Payment Method
ADVANCED_YN VARCHAR2 (80)
Advance Receipt Flag
INVOICE_DATE DATE

Invoice date
CUST_ACCOUNT_ID NUMBER (15)
Customer Account Identifier
UNAPPLIED_AMOUNT NUMBER

Unapplied Amount
ONACCOUNT_AMOUNT NUMBER

On Account Amount
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Invoice Currency Code
Query Text

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


SELECT CASH_RECEIPT_ID
,      INVOICE_NUMBER
,      RECEIPT_NUMBER
,      RECEIPT_DATE
,      RECEIPT_STATUS
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_AMOUNT
,      AMOUNT_APPLIED
,      RECEIPT_TYPE_CODE
,      PAYMENT_METHOD
,      ADVANCED_YN
,      INVOICE_DATE
,      CUST_ACCOUNT_ID
,      UNAPPLIED_AMOUNT
,      ONACCOUNT_AMOUNT
,      INVOICE_CURRENCY_CODE
FROM APPS.OKL_CS_INV_RECEIPTS_UV;

Dependencies

[top of page]

APPS.OKL_CS_INV_RECEIPTS_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewOKL_CS_TRX_PAYMENTS_UV

APPS.OKL_CS_INV_RECEIPTS_UV is not referenced by any database object