eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_MRP_BUCKETED_FORECASTS_V

Product:	ICX - Oracle iProcurement
Description:	Bucketed Forecast Information View
Implementation/DBA Data:	APPS.ICX_MRP_BUCKETED_FORECASTS_V

View Text

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
, ABS(NUMBER5-NUMBER9)/NUMBER5
FROM MRP_FORM_QUERY

Columns

Name
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