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

VIEW: APPS.OKL_BPD_AR_INVOICES_V

Object Details
Object Name: OKL_BPD_AR_INVOICES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_AR_INVOICES_V
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
DUE_DATE DATE
Yes Due date of this installment
DATE_CONSOLIDATED DATE
Yes Invoice date
STATUS VARCHAR2 (30)
The status of the transaction
CLASS_ID NUMBER (15) Yes Transaction type identifier
CLASS VARCHAR2 (20)
Transaction type name
INVOICE_ID NUMBER (15) Yes Invoice identifier
TRX_NUMBER VARCHAR2 (20) Yes Transaction number
IXX_ID NUMBER (15)
Customer identifier
CURRENCY_CODE VARCHAR2 (15)
Invoice currency
AMOUNT_DUE_ORIGINAL NUMBER
Yes The original amount due
BALANCE NUMBER
Yes The current amount due remaining
SITE_USE_ID NUMBER (15)
Site use identifier billed
BILL_TO_SITE_USE_ID NUMBER (15)
Address identifier
RECEIPT_METHOD_ID NUMBER (15)
Receipt method identifier
INF_NAME VARCHAR2 (150)
Invoice Fromnat Name
ORG_ID NUMBER (15)
Organization identifier
PAY_SCH_CLASS VARCHAR2 (20) Yes Lookup code for the class of the payment schedule
CUSTOMER_ID NUMBER (15)
Identifies the customer associated with the item
Query Text

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


SELECT DUE_DATE
,      DATE_CONSOLIDATED
,      STATUS
,      CLASS_ID
,      CLASS
,      INVOICE_ID
,      TRX_NUMBER
,      IXX_ID
,      CURRENCY_CODE
,      AMOUNT_DUE_ORIGINAL
,      BALANCE
,      SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      RECEIPT_METHOD_ID
,      INF_NAME
,      ORG_ID
,      PAY_SCH_CLASS
,      CUSTOMER_ID
FROM APPS.OKL_BPD_AR_INVOICES_V;

Dependencies

[top of page]

APPS.OKL_BPD_AR_INVOICES_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymAR_PAYMENT_SCHEDULES_ALL
ViewOKX_CUST_SITE_USES_V
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUST_TRX_TYPES_ALL
APPS.OKL_BPD_AR_INVOICES_V is referenced by following:

SchemaAPPS
ViewOKL_BPD_INV_SRCH_V
Package BodyOKL_LTE_CHRG_PVT - show dependent code
Package BodyOKL_LTE_INT_PVT - show dependent code
Package BodyOKL_PAY_INVOICES_DISB_PVT - show dependent code
PL/SQL PackageOKL_PAY_INVOICES_DISB_PVT - show dependent code