[Home] [Help]
1021: P.END_DATE,
1022: SUM(FI.ITEM_QUANTITY),
1023: MIN(FI.FORECAST_ITEM_ID)
1024: FROM PA_FORECAST_ITEMS FI,
1025: PA_FORECAST_ITEM_DETAILS FID,
1026: PA_PERIODS_ALL P
1027: WHERE FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99)
1028: AND P.ORG_ID = c_org_id /* Bug 5657334 */
1029: AND P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME
1050: GLP.END_DATE,
1051: SUM(FI.ITEM_QUANTITY),
1052: MIN(FI.FORECAST_ITEM_ID)
1053: FROM PA_FORECAST_ITEMS FI,
1054: PA_FORECAST_ITEM_DETAILS FID,
1055: GL_PERIODS GLP
1056: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1057: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1058: AND FID.NET_ZERO_FLAG = 'N'
1078: null period_name,
1079: min(fi.item_Date) start_date,
1080: max(fi.item_Date) end_date -- Bug 4549862: Changed min to max.
1081: FROM PA_FORECAST_ITEMS FI,
1082: PA_FORECAST_ITEM_DETAILS FID
1083: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1084: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1085: AND FID.NET_ZERO_FLAG = 'N'
1086: AND FI.ERROR_FLAG = 'N'
1138: RLM.RESOURCE_ID,
1139: RLM.RESOURCE_LIST_ID,
1140: RLM.ALIAS
1141: FROM PA_FORECAST_ITEMS FI,
1142: PA_FORECAST_ITEM_DETAILS FID,
1143: PA_PERIODS_ALL P,
1144: PA_RES_LIST_MAP_TMP4 TMP4,
1145: PA_RESOURCE_ASSIGNMENTS RA,
1146: PA_RESOURCE_LIST_MEMBERS RLM
1213: RLM.RESOURCE_ID,
1214: RLM.RESOURCE_LIST_ID,
1215: RLM.ALIAS
1216: FROM PA_FORECAST_ITEMS FI,
1217: PA_FORECAST_ITEM_DETAILS FID,
1218: GL_PERIODS GLP,
1219: PA_RES_LIST_MAP_TMP4 TMP4,
1220: PA_RESOURCE_ASSIGNMENTS RA,
1221: PA_RESOURCE_LIST_MEMBERS RLM
1288: RLM.RESOURCE_ID,
1289: RLM.RESOURCE_LIST_ID,
1290: RLM.ALIAS
1291: FROM PA_FORECAST_ITEMS FI,
1292: PA_FORECAST_ITEM_DETAILS FID,
1293: PA_RES_LIST_MAP_TMP4 TMP4,
1294: PA_RESOURCE_ASSIGNMENTS RA,
1295: PA_RESOURCE_LIST_MEMBERS RLM
1296: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID