[Home] [Help] [Dependency Information]
Object Name: | FIIBV_AP_IVTY_INV_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FIIBV_AP_IVTY_INV_LCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INV_PK | VARCHAR2 | (122) | Unique Identifier | |
INV_TYPE_FK | VARCHAR2 | (25) | Foreign key to invoice type | |
INV_ID | VARCHAR2 | (40) | Invoice identifier | |
NAME | VARCHAR2 | (50) | Yes | Displayed name for the record |
INV_NAME | VARCHAR2 | (50) | Yes | Invoice Name |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
INV_SOURCE | VARCHAR2 | (25) | Invoice source of invoice being held | |
CANCELLED_DATE | DATE | Cancelled date | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
DELETION_DATE | VARCHAR2 | (0) | Deletion date of the record | |
INV_DP | VARCHAR2 | (0) | Unique Invoice name for display | |
_DF:INV:_EDW | CHAR | (24) | This column is for internal use only | |
_DF:GOV:_EDW | CHAR | (35) | This column is for internal use only | |
_DF:JGI:_EDW | CHAR | (24) | This column is for internal use only |
Cut, paste (and edit) the following text to query this object:
SELECT INV_PK
, INV_TYPE_FK
, INV_ID
, NAME
, INV_NAME
, INSTANCE
, INV_SOURCE
, CANCELLED_DATE
, LAST_UPDATE_DATE
, CREATION_DATE
, DELETION_DATE
, INV_DP
, _DF:INV:_EDW
, _DF:GOV:_EDW
, _DF:JGI:_EDW
FROM APPS.FIIBV_AP_IVTY_INV_LCV;
|
|
|