eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PROJECTS_FOR_ACCUM_V

Line 928: FROM pa_projects_for_accum_v proj

924: /* Added for bug 1751445 Cause Performance */
925: /*Commented for perf bug #3672175 and redefined below */
926: /* CURSOR all_valid_proj IS
927: SELECT DISTINCT proj.project_id, proj.segment1
928: FROM pa_projects_for_accum_v proj
929: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
930: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
931: AND NOT EXISTS (SELECT 1
932: FROM pa_projects_for_accum proj_invalid

Line 1073: FROM pa_projects_for_accum_v proj

1069: INSERT INTO pa_projects_for_accum
1070: (project_id, request_id, action_flag, segment1, exception_flag)
1071: SELECT proj.project_id, x_request_id request_id,
1072: 'CS' action_flag, proj.segment1, 'N'
1073: FROM pa_projects_for_accum_v proj
1074: WHERE proj.segment1
1075: BETWEEN l_project_num_from AND l_project_num_to
1076: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1077: AND x_actual_cost_flag = 'Y'

Line 1089: FROM pa_projects_for_accum_v proj

1085: AND cdl.resource_accumulated_flag='N')
1086: UNION ALL
1087: SELECT proj.project_id, x_request_id request_id,
1088: 'RV' action_flag, proj.segment1, 'N'
1089: FROM pa_projects_for_accum_v proj
1090: WHERE proj.segment1
1091: BETWEEN l_project_num_from AND l_project_num_to
1092: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1093: AND x_revenue_flag = 'Y'

Line 1105: FROM pa_projects_for_accum_v proj

1101: AND dr.released_date IS NOT NULL)
1102: UNION ALL
1103: SELECT proj.project_id, x_request_id request_id,
1104: 'RL' action_flag, proj.segment1, 'N'
1105: FROM pa_projects_for_accum_v proj
1106: WHERE proj.segment1
1107: BETWEEN l_project_num_from AND l_project_num_to
1108: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1109: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1118: FROM pa_projects_for_accum_v proj

1114: 'N') = 'N')
1115: /* UNION ALL
1116: SELECT proj.project_id, x_request_id request_id,
1117: 'CM' action_flag, proj.segment1, 'N'
1118: FROM pa_projects_for_accum_v proj
1119: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1120: AND x_commitments_flag = 'Y'
1121: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1122: UNION ALL

Line 1125: FROM pa_projects_for_accum_v proj

1121: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1122: UNION ALL
1123: SELECT proj.project_id, x_request_id request_id,
1124: 'BD' action_flag, proj.segment1, 'N'
1125: FROM pa_projects_for_accum_v proj
1126: WHERE proj.segment1
1127: BETWEEN l_project_num_from AND l_project_num_to
1128: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1129: AND x_budgets_flag = 'Y'

Line 1139: FROM pa_projects_for_accum_v proj

1135: AND bud.resource_accumulated_flag = 'N')
1136: UNION ALL
1137: SELECT proj.project_id, x_request_id request_id,
1138: 'TR' action_flag, proj.segment1, 'Y'
1139: FROM pa_projects_for_accum_v proj
1140: WHERE proj.segment1
1141: BETWEEN l_project_num_from AND l_project_num_to
1142: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1143: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1151: FROM pa_projects_for_accum_v proj

1147: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')
1148: UNION ALL
1149: SELECT proj.project_id, x_request_id request_id,
1150: 'PR' action_flag, proj.segment1, 'N'
1151: FROM pa_projects_for_accum_v proj
1152: WHERE proj.segment1
1153: BETWEEN l_project_num_from AND l_project_num_to
1154: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1155: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1162: FROM pa_projects_for_accum_v proj

1158: proj.closed_date, l_current_start_date) = 'Y'
1159: UNION ALL
1160: SELECT proj.project_id, x_request_id request_id,
1161: 'BK' action_flag, proj.segment1, 'Y'
1162: FROM pa_projects_for_accum_v proj
1163: WHERE proj.segment1
1164: BETWEEN l_project_num_from AND l_project_num_to
1165: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1166: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1173: FROM pa_projects_for_accum_v proj

1169: proj.closed_date, l_current_start_date) = 'Y'
1170: UNION ALL
1171: SELECT proj.project_id, x_request_id request_id,
1172: 'CL' action_flag, proj.segment1, 'N'
1173: FROM pa_projects_for_accum_v proj
1174: WHERE proj.segment1
1175: BETWEEN l_project_num_from AND l_project_num_to
1176: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1177: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1184: FROM pa_projects_for_accum_v proj

1180: proj.closed_date, l_current_start_date) = 'Y'
1181: UNION ALL
1182: SELECT proj.project_id, x_request_id request_id,
1183: 'PT' action_flag, proj.segment1, 'Y'
1184: FROM pa_projects_for_accum_v proj
1185: WHERE proj.segment1
1186: BETWEEN l_project_num_from AND l_project_num_to
1187: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1188: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1195: FROM pa_projects_for_accum_v proj

1191: proj.closed_date, l_current_start_date) = 'Y'
1192: UNION ALL
1193: SELECT proj.project_id, x_request_id request_id, 'TX' action_flag,
1194: proj.segment1, 'N'
1195: FROM pa_projects_for_accum_v proj
1196: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1197: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1198: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1199: AND (x_actual_cost_flag = 'Y' OR x_revenue_flag = 'Y')

Line 1214: FROM pa_projects_for_accum_v proj

1210: AND x_revenue_flag = 'Y')
1211: UNION ALL
1212: SELECT proj.project_id, x_request_id request_id, 'TM' action_flag,
1213: proj.segment1, 'N'
1214: FROM pa_projects_for_accum_v proj
1215: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1216: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1217: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1218: AND x_commitments_flag = 'Y'