[Home] [Help]
991: PA_WORK_TYPES_B WB,
992: PA_PROJECT_ROLE_TYPES PR,
993: PA_PROJECTS_ALL P,
994: PA_RESOURCE_TXN_ATTRIBUTES RTA,
995: PA_FORECAST_ITEMS FI
996: WHERE PA.PROJECT_ID = p_project_id
997: AND PA.PROJECT_ROLE_ID = PR.PROJECT_ROLE_ID
998: AND P.PROJECT_ID = p_project_id
999: AND WB.WORK_TYPE_ID = PA.WORK_TYPE_ID(+)
1020: P.START_DATE,
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 */
1049: GLP.START_DATE,
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'
1077: MIN(FI.FORECAST_ITEM_ID),
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'
1137: RLM.RESOURCE_LIST_MEMBER_ID,
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,
1212: RLM.RESOURCE_LIST_MEMBER_ID,
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,
1287: RLM.RESOURCE_LIST_MEMBER_ID,
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
1582: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1583: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1584: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1585:
1586: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1587: /* Added for Org Forecasting */
1588:
1589: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1590: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;