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


VIEW: APPS.INVBV_FUTURE_ITEM_STATUSES

Object Details
Object Name: INVBV_FUTURE_ITEM_STATUSES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVBV_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)
ORGANIZATION_NAME VARCHAR2 (240) Yes
ORGANIZATION_CODE VARCHAR2 (3)
ITEM_STATUS_CODE VARCHAR2 (10)

START_EFFECTIVE_DATE DATE
Yes
IMPLEMENTED_DATE DATE


_LA:STATUS_PENDING_FLAG CHAR (46)
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATED_DATE DATE
Yes
CREATED_BY NUMBER
Yes
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:STATUS_PENDING_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVBV_FUTURE_ITEM_STATUSES;

Dependencies

[top of page]

APPS.INVBV_FUTURE_ITEM_STATUSES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_PENDING_ITEM_STATUS
SynonymMTL_SYSTEM_ITEMS

APPS.INVBV_FUTURE_ITEM_STATUSES is not referenced by any database object