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

VIEW: APPS.FV_INV_STATUSES_V

Object Details
Object Name: FV_INV_STATUSES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_INV_STATUSES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


FV_INV_STATUSES_V is the base view for the Invoice Status read-only form, and has the details of all the late invoices.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15) Yes Organization identifier
CUSTOMER_ID NUMBER (15) Yes Customer identifier
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
CUSTOMER_NUMBER VARCHAR2 (30) Yes Customer number
CUSTOMER_TRX_ID NUMBER (15) Yes Customer transaction identifier
TRX_NUMBER VARCHAR2 (20) Yes Transaction number
RECEIVABLE_TYPE_ID NUMBER (15) Yes Receivable type identifier
DESCRIPTION VARCHAR2 (80) Yes Receivable type description
AMOUNT_DUE_REMAINING NUMBER

Remaining amount still due
DAYS_LATE NUMBER

Number of days late
Query Text

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


SELECT ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      RECEIVABLE_TYPE_ID
,      DESCRIPTION
,      AMOUNT_DUE_REMAINING
,      DAYS_LATE
FROM APPS.FV_INV_STATUSES_V;

Dependencies

[top of page]

APPS.FV_INV_STATUSES_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFV_FINANCE_CHARGE_CONTROLS
ViewFV_LOOKUP_CODES
SynonymFV_RECEIVABLE_TYPES
SynonymFV_REC_CUST_TRX_TYPES_ALL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymRA_CUSTOMER_TRX_ALL
APPS.FV_INV_STATUSES_V is referenced by following:

SchemaAPPS
ViewFV_INV_STATCUST_V