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

VIEW: APPS.OKL_CS_CONT_INV_RECEIPTS_UV

Object Details
Object Name: OKL_CS_CONT_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
KHR_ID NUMBER

CASH_RECEIPT_ID NUMBER (15)
INVOICE_NUMBER VARCHAR2 (150)
RECEIPT_NUMBER VARCHAR2 (30)
RECEIPT_DATE DATE

RECEIPT_STATUS VARCHAR2 (80)
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_AMOUNT NUMBER

AMOUNT_APPLIED NUMBER

RECEIPT_TYPE_CODE VARCHAR2 (3)
PAYMENT_METHOD VARCHAR2 (30)
ADVANCED_YN VARCHAR2 (80)
INVOICE_DATE DATE

CUST_ACCOUNT_ID NUMBER (15)
UNAPPLIED_AMOUNT NUMBER

Receipt unapplied amount
ONACCOUNT_AMOUNT NUMBER

Receipt On Account Amount
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Query Text

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


SELECT KHR_ID
,      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_CONT_INV_RECEIPTS_UV;

Dependencies

[top of page]

APPS.OKL_CS_CONT_INV_RECEIPTS_UV references the following:

SchemaAPPS
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewOKL_CS_TRX_PAYMENTS_UV

APPS.OKL_CS_CONT_INV_RECEIPTS_UV is not referenced by any database object