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

VIEW: APPS.ICX_MRP_BUCKETED_FORECASTS_V

Object Details
Object Name: ICX_MRP_BUCKETED_FORECASTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_MRP_BUCKETED_FORECASTS_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The ICX_MRP_BUCKETED_FORECASTS_V view is used by the Self-Service Web
Applications to display BUCKETED forecast information for an item.
Data in this view is queried from the MRP_FORM_QUERY table which gets
populated when the user navigates to the Bucketed Detail section of an
item forecast.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query identifier
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who colmn
DATE1 DATE

Generic Date Column
DATE2 DATE

Generic Date Column
DATE3 DATE

Generic Date Column
DATE4 DATE

Generic Date Column
DATE5 DATE

Generic Date Column
DATE6 DATE

Generic Date Column
DATE7 DATE

Generic Date Column
DATE8 DATE

Generic Date Column
NUMBER1 NUMBER

Generic Number Column
NUMBER2 NUMBER

Generic Number Column
NUMBER3 NUMBER

Generic Number Column
NUMBER4 NUMBER

Generic Number Column
NUMBER5 NUMBER

Generic Number Column
NUMBER6 NUMBER

Generic Number Column
NUMBER7 NUMBER

Generic Number Column
NUMBER8 NUMBER

Generic Number Column
NUMBER9 NUMBER

Generic Number Column
NUMBER10 NUMBER

Generic Number Column
NUMBER11 NUMBER

Generic Number Column
NUMBER12 NUMBER

Generic Number Column
NUMBER13 NUMBER

Generic Number Column
NUMBER14 NUMBER

Generic Number Column
NUMBER15 NUMBER

Generic Number Column
REQUEST_ID NUMBER

Concurrent Who Column
CHAR1 VARCHAR2 (80)
Generic Character Column
CHAR2 VARCHAR2 (80)
Generic Character Column
CHAR3 VARCHAR2 (80)
Generic Character Column
CHAR4 VARCHAR2 (80)
Generic Character Column
CHAR5 VARCHAR2 (80)
Generic Character Column
CHAR6 VARCHAR2 (80)
Generic Character Column
CHAR7 VARCHAR2 (80)
Generic Character Column
CHAR8 VARCHAR2 (80)
Generic Character Column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent who column
PROGRAM_ID NUMBER

Concurrent who column
NUMBER16 NUMBER

Generic number column
Query Text

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


SELECT QUERY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
,      REQUEST_ID
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      NUMBER16
FROM APPS.ICX_MRP_BUCKETED_FORECASTS_V;

Dependencies

[top of page]

APPS.ICX_MRP_BUCKETED_FORECASTS_V references the following:

SchemaAPPS
SynonymMRP_FORM_QUERY

APPS.ICX_MRP_BUCKETED_FORECASTS_V is not referenced by any database object