[Home] [Help]
1003: PA_WORK_TYPES_B WB,
1004: PA_PROJECT_ROLE_TYPES PR,
1005: PA_PROJECTS_ALL P,
1006: PA_RESOURCE_TXN_ATTRIBUTES RTA,
1007: PA_FORECAST_ITEMS FI
1008: WHERE PA.PROJECT_ID = p_project_id
1009: AND PA.PROJECT_ROLE_ID = PR.PROJECT_ROLE_ID
1010: AND P.PROJECT_ID = p_project_id
1011: AND WB.WORK_TYPE_ID = PA.WORK_TYPE_ID(+)
1032: P.START_DATE,
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 */
1061: GLP.START_DATE,
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'
1089: MIN(FI.FORECAST_ITEM_ID),
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'
1149: RLM.RESOURCE_LIST_MEMBER_ID,
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,
1224: RLM.RESOURCE_LIST_MEMBER_ID,
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,
1299: RLM.RESOURCE_LIST_MEMBER_ID,
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
1594: l_projfunc_bil_rate_type PA_PROJECTS_ALL.PROJECT_BIL_RATE_TYPE%TYPE;
1595: l_projfunc_bil_rate_date PA_PROJECTS_ALL.PROJECT_BIL_RATE_DATE%TYPE;
1596: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.PROJECT_BIL_EXCHANGE_RATE%TYPE;
1597:
1598: l_system_linkage Pa_Forecast_Items.EXPENDITURE_TYPE_CLASS%TYPE;
1599: /* Added for Org Forecasting */
1600:
1601: l_cost_job_group_id Pa_Projects_All.Cost_Job_Group_Id%TYPE;
1602: l_prj_rate_date Pa_Projects_All.PROJECT_RATE_DATE%TYPE;