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


VIEW: APPS.AP_INVOICES_WWW_V

Object Details
Object Name: AP_INVOICES_WWW_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_INVOICES_WWW_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
DESCRIPTION VARCHAR2 (240)

INVOICE_AMOUNT NUMBER


INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
INVOICE_AMOUNT_CURRENCY_CODE VARCHAR2 (56)
WITHHELD_AMOUNT_CURRENCY_CODE VARCHAR2 (56)
INVOICE_DATE DATE

INVOICE_ID NUMBER (15) Yes
INVOICE_NUM VARCHAR2 (50) Yes
DUE_DATE DATE

GROSS_AMOUNT NUMBER

AMOUNT_REMAINING NUMBER

DISCOUNT_DATE DATE

DISCOUNT_AMOUNT_AVAILABLE NUMBER

INVOICE_TYPE VARCHAR2 (80)
PAYMENT_STATUS VARCHAR2 (80)
PO_NUMBER VARCHAR2 (4000)
PAYMENT_NUMBER VARCHAR2 (4000)
VENDOR_SITE_CODE VARCHAR2 (15) Yes
VENDOR_SITE_ID NUMBER (15)
VENDOR_ID NUMBER (15)
Query Text

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


SELECT DESCRIPTION
,      INVOICE_AMOUNT
,      INVOICE_CURRENCY_CODE
,      INVOICE_AMOUNT_CURRENCY_CODE
,      WITHHELD_AMOUNT_CURRENCY_CODE
,      INVOICE_DATE
,      INVOICE_ID
,      INVOICE_NUM
,      DUE_DATE
,      GROSS_AMOUNT
,      AMOUNT_REMAINING
,      DISCOUNT_DATE
,      DISCOUNT_AMOUNT_AVAILABLE
,      INVOICE_TYPE
,      PAYMENT_STATUS
,      PO_NUMBER
,      PAYMENT_NUMBER
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_ID
FROM APPS.AP_INVOICES_WWW_V;

Dependencies

[top of page]

APPS.AP_INVOICES_WWW_V references the following:

SchemaAPPS
SynonymAP_INVOICES
PL/SQL PackageAP_INVOICES_PKG - show dependent code
PL/SQL PackageAP_INVOICE_PAYMENTS_PKG - show dependent code
ViewAP_LOOKUP_CODES
SynonymAP_PAYMENT_SCHEDULES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewPO_VENDOR_SITES

APPS.AP_INVOICES_WWW_V is not referenced by any database object