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

VIEW: APPS.INVFV_FUTURE_ITEM_STATUSES

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

View Type

A Business Intelligence System view


This shows the Future Effective Item Status which is used to define and store the history of the item statuses that are or can be assigned to an item.


[View Source]

Columns
Name Datatype Length Mandatory Comments
_KF:ITEM_NAME CHAR (15)
Name of item
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ITEM_STATUS_CODE VARCHAR2 (10)
Status code
START_EFFECTIVE_DATE DATE
Yes Effective date
IMPLEMENTED_DATE DATE

Implementation date
_LA:PENDING_FLAG CHAR (46)
Determines if status is pending
INVENTORY_ITEM_ID NUMBER
Yes Item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
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 _KF:ITEM_NAME
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      ITEM_STATUS_CODE
,      START_EFFECTIVE_DATE
,      IMPLEMENTED_DATE
,      _LA:PENDING_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_FUTURE_ITEM_STATUSES;

Dependencies

[top of page]

APPS.INVFV_FUTURE_ITEM_STATUSES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_PENDING_ITEM_STATUS
SynonymMTL_SYSTEM_ITEMS

APPS.INVFV_FUTURE_ITEM_STATUSES is not referenced by any database object