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

VIEW: APPS.FV_INVOICE_MASTER_V

Object Details
Object Name: FV_INVOICE_MASTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_INVOICE_MASTER_V
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 Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes Invoice identifier
VENDOR_ID NUMBER (15)
Supplier identifier
VENDOR_SITE_ID NUMBER (15)
Supplier site identifier
INVOICE_NUM VARCHAR2 (50) Yes Invoice number
INVOICE_DATE DATE

Invoice Date
INVOICE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Type of invoice
INVOICE_AMOUNT NUMBER

Invoice Amount
INVOICE_STATUS_FLAG VARCHAR2 (50) Yes Invoice Status
PAYMENT_STATUS_FLAG VARCHAR2 (14)
Payment Status
HOLD_STATUS NUMBER

Hold Status
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
Name of pay group
STATUS VARCHAR2 (4000)
Query Text

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


SELECT INVOICE_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_TYPE_LOOKUP_CODE
,      INVOICE_AMOUNT
,      INVOICE_STATUS_FLAG
,      PAYMENT_STATUS_FLAG
,      HOLD_STATUS
,      PAY_GROUP_LOOKUP_CODE
,      STATUS
FROM APPS.FV_INVOICE_MASTER_V;

Dependencies

[top of page]

APPS.FV_INVOICE_MASTER_V references the following:

SchemaAPPS
SynonymAP_INVOICES
PL/SQL PackageAP_INVOICES_PKG - show dependent code
PL/SQL PackageAP_INVOICES_UTILITY_PKG - show dependent code

APPS.FV_INVOICE_MASTER_V is not referenced by any database object