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

VIEW: APPS.INVFV_ITEM_STATUS_CODES

Object Details
Object Name: INVFV_ITEM_STATUS_CODES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVFV_ITEM_STATUS_CODES
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_STATUS_CODE VARCHAR2 (10) Yes Status code
DESCRIPTION VARCHAR2 (240)
Description of status code
END_EFFECTIVE_DATE DATE

Disable date
_DF CHAR (26)
Descriptive flexfield
LAST_UPDATED_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATED_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT ITEM_STATUS_CODE
,      DESCRIPTION
,      END_EFFECTIVE_DATE
,      _DF
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_ITEM_STATUS_CODES;

Dependencies

[top of page]

APPS.INVFV_ITEM_STATUS_CODES references the following:

SchemaAPPS
SynonymMTL_ITEM_STATUS

APPS.INVFV_ITEM_STATUS_CODES is not referenced by any database object