[Home] [Help] [Dependency Information]
Object Name: | INVBV_ITEM_STATUS_CODES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.INVBV_ITEM_STATUS_CODES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows the status of an item. The status optionally controls several "function controlling" item attributes (status attributes) and can be used to disable the item from being used by the various application products.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
END_EFFECTIVE_DATE | DATE | |||
LAST_UPDATED_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATED_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_STATUS_CODE
, DESCRIPTION
, END_EFFECTIVE_DATE
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
, CREATED_DATE
, CREATED_BY
FROM APPS.INVBV_ITEM_STATUS_CODES;
APPS.INVBV_ITEM_STATUS_CODES is not referenced by any database object
|
|
|