[Home] [Help]
1033: P.END_DATE,
1034: SUM(FI.ITEM_QUANTITY),
1035: MIN(FI.FORECAST_ITEM_ID)
1036: FROM PA_FORECAST_ITEMS FI,
1037: PA_FORECAST_ITEM_DETAILS FID,
1038: PA_PERIODS_ALL P
1039: WHERE FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99)
1040: AND P.ORG_ID = c_org_id /* Bug 5657334 */
1041: AND P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME
1062: GLP.END_DATE,
1063: SUM(FI.ITEM_QUANTITY),
1064: MIN(FI.FORECAST_ITEM_ID)
1065: FROM PA_FORECAST_ITEMS FI,
1066: PA_FORECAST_ITEM_DETAILS FID,
1067: GL_PERIODS GLP
1068: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1069: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1070: AND FID.NET_ZERO_FLAG = 'N'
1090: null period_name,
1091: min(fi.item_Date) start_date,
1092: max(fi.item_Date) end_date -- Bug 4549862: Changed min to max.
1093: FROM PA_FORECAST_ITEMS FI,
1094: PA_FORECAST_ITEM_DETAILS FID
1095: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1096: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1097: AND FID.NET_ZERO_FLAG = 'N'
1098: AND FI.ERROR_FLAG = 'N'
1150: RLM.RESOURCE_ID,
1151: RLM.RESOURCE_LIST_ID,
1152: RLM.ALIAS
1153: FROM PA_FORECAST_ITEMS FI,
1154: PA_FORECAST_ITEM_DETAILS FID,
1155: PA_PERIODS_ALL P,
1156: PA_RES_LIST_MAP_TMP4 TMP4,
1157: PA_RESOURCE_ASSIGNMENTS RA,
1158: PA_RESOURCE_LIST_MEMBERS RLM
1225: RLM.RESOURCE_ID,
1226: RLM.RESOURCE_LIST_ID,
1227: RLM.ALIAS
1228: FROM PA_FORECAST_ITEMS FI,
1229: PA_FORECAST_ITEM_DETAILS FID,
1230: GL_PERIODS GLP,
1231: PA_RES_LIST_MAP_TMP4 TMP4,
1232: PA_RESOURCE_ASSIGNMENTS RA,
1233: PA_RESOURCE_LIST_MEMBERS RLM
1300: RLM.RESOURCE_ID,
1301: RLM.RESOURCE_LIST_ID,
1302: RLM.ALIAS
1303: FROM PA_FORECAST_ITEMS FI,
1304: PA_FORECAST_ITEM_DETAILS FID,
1305: PA_RES_LIST_MAP_TMP4 TMP4,
1306: PA_RESOURCE_ASSIGNMENTS RA,
1307: PA_RESOURCE_LIST_MEMBERS RLM
1308: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID