DBA Data[Home] [Help]

APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_FORECAST_ITEM_DETAILS

Line 304: PA_FORECAST_ITEM_DETAILS FID,

300: P.START_DATE,P.END_DATE,SUM(FI.ITEM_QUANTITY),
301: MIN(FI.FORECAST_ITEM_ID)
302: FROM
303: PA_FORECAST_ITEMS FI,
304: PA_FORECAST_ITEM_DETAILS FID,
305: PA_PERIODS_ALL P
306: WHERE
307: FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99) AND
308: P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME AND

Line 327: PA_FORECAST_ITEM_DETAILS FID,

323: GLP.START_DATE, GLP.END_DATE,SUM(FI.ITEM_QUANTITY),
324: MIN(FI.FORECAST_ITEM_ID)
325: FROM
326: PA_FORECAST_ITEMS FI,
327: PA_FORECAST_ITEM_DETAILS FID,
328: GL_PERIODS GLP, /* Added the ending comma for Bug 3512491 */
329: PA_IMPLEMENTATIONS IMP, /* Added the table for Bug 3512491 */
330: GL_SETS_OF_BOOKS SOB /* Added the table for Bug 3512491 */
331: WHERE