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


VIEW: APPS.OKL_CS_PAY_INVOICES_UV

Object Details
Object Name: OKL_CS_PAY_INVOICES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_PAY_INVOICES_UV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

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
IPVS_ID NUMBER
Yes
CURRENCY VARCHAR2 (15) Yes
PAYMENT_METHOD_CODE VARCHAR2 (80) Yes
INVOICE_DATE DATE
Yes
TERM_ID NUMBER

INVOICE_NUMBER VARCHAR2 (50)
INVOICE_TYPE VARCHAR2 (240)
AMOUNT NUMBER
Yes
TRANSACTION_TYPE VARCHAR2 (80) Yes
VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_CODE VARCHAR2 (15)
INVOICE_STATUS VARCHAR2 (80) Yes
PAY_GROUP_LOOKUP_CODE VARCHAR2 (30)
VENDOR_INVOICE_NUMBER VARCHAR2 (240) Yes
VENDOR_ID NUMBER
Yes
PAYMENTS_TERMS VARCHAR2 (50) Yes
PAID_AMOUNT NUMBER

PAYMENT_METHOD VARCHAR2 (80) Yes
CNSLD_AP_INV_ID NUMBER
Yes
INVOICE_ID NUMBER (15) Yes
Query Text

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


SELECT IPVS_ID
,      CURRENCY
,      PAYMENT_METHOD_CODE
,      INVOICE_DATE
,      TERM_ID
,      INVOICE_NUMBER
,      INVOICE_TYPE
,      AMOUNT
,      TRANSACTION_TYPE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      INVOICE_STATUS
,      PAY_GROUP_LOOKUP_CODE
,      VENDOR_INVOICE_NUMBER
,      VENDOR_ID
,      PAYMENTS_TERMS
,      PAID_AMOUNT
,      PAYMENT_METHOD
,      CNSLD_AP_INV_ID
,      INVOICE_ID
FROM APPS.OKL_CS_PAY_INVOICES_UV;

Dependencies

[top of page]

APPS.OKL_CS_PAY_INVOICES_UV references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_TERMS_TL
SynonymFND_APPLICATION
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKL_CNSLD_AP_INVS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.OKL_CS_PAY_INVOICES_UV is not referenced by any database object