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


VIEW: APPS.MRPBV_FORECAST_ITEMS

Object Details
Object Name: MRPBV_FORECAST_ITEMS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRPBV_FORECAST_ITEMS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows the items that are entered on an item forecast.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Yes
FORECAST_NAME VARCHAR2 (10) Yes
_KF:ITEM_NUMBER CHAR (15)
ALTERNATE_BILL VARCHAR2 (10)
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      FORECAST_NAME
,      _KF:ITEM_NUMBER
,      ALTERNATE_BILL
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPBV_FORECAST_ITEMS;

Dependencies

[top of page]

APPS.MRPBV_FORECAST_ITEMS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMRP_FORECAST_ITEMS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS

APPS.MRPBV_FORECAST_ITEMS is not referenced by any database object