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_BIS_SUMMARY dependencies on PA_PROJECT_TYPES

Line 43: , pa_project_types pt

39: , TA.TOT_REVENUE ACT_REVENUE
40: , 0 BUD_COST
41: , 0 BUD_REVENUE
42: FROM pa_projects p
43: , pa_project_types pt
44: , pa_txn_accum ta
45: , pa_implementations i
46: , gl_period_statuses per
47: WHERE i.accumulation_period_type = 'GL'

Line 71: , pa_project_types pt

67: , TA.TOT_REVENUE ACT_REVENUE
68: , 0 BUD_COST
69: , 0 BUD_REVENUE
70: FROM pa_projects p
71: , pa_project_types pt
72: , pa_txn_accum ta
73: , pa_implementations i
74: , pa_periods per
75: WHERE i.accumulation_period_type = 'PA'

Line 95: , pa_project_types pt

91: , 0 ACT_REVENUE
92: , BPA.BASE_BURDENED_COST BUD_COST
93: , BPA.BASE_REVENUE BUD_REVENUE
94: FROM pa_projects p
95: , pa_project_types pt
96: , pa_budget_by_pa_period_v bpa
97: , pa_implementations I
98: , gl_period_statuses per
99: WHERE i.accumulation_period_type = 'GL'

Line 124: , pa_project_types pt

120: , 0 ACT_REVENUE
121: , BPA.BASE_BURDENED_COST BUD_COST
122: , BPA.BASE_REVENUE BUD_REVENUE
123: FROM pa_projects p
124: , pa_project_types pt
125: , pa_budget_by_pa_period_v bpa
126: , pa_implementations i
127: WHERE i.accumulation_period_type = 'PA'
128: AND p.project_type = pt.project_type

Line 147: , pa_project_types pt

143: , 0 ACT_REVENUE
144: , 0 BUD_COST
145: , 0 BUD_REVENUE
146: FROM pa_projects p
147: , pa_project_types pt
148: , pa_implementations i
149: , gl_period_statuses per
150: WHERE i.accumulation_period_type = 'GL'
151: AND p.project_type = pt.project_type

Line 172: , pa_project_types pt

168: , 0 ACT_REVENUE
169: , 0 BUD_COST
170: , 0 BUD_REVENUE
171: FROM pa_projects p
172: , pa_project_types pt
173: , pa_implementations i
174: , pa_periods per
175: WHERE i.accumulation_period_type = 'PA'
176: AND p.project_type = pt.project_type

Line 219: pa_project_types pt ,

215: 0 ACT_REVENUE,
216: 0 BUD_COST,
217: 0 BUD_REVENUE
218: FROM pa_projects p ,
219: pa_project_types pt ,
220: pa_implementations i ,
221: pa_periods per ,
222: pa_class_categories cc ,
223: pa_project_classes pc

Line 246: , pa_project_types pt

242: 0 BUD_COST,
243: 0 BUD_REVENUE
244: FROM
245: pa_projects p
246: , pa_project_types pt
247: , pa_txn_accum ta
248: , pa_implementations i ,
249: pa_periods per ,
250: pa_class_categories cc ,

Line 278: pa_project_types pt ,

274: 0 ACT_REVENUE,
275: BPA.BASE_BURDENED_COST BUD_COST,
276: BPA.BASE_REVENUE BUD_REVENUE
277: FROM pa_projects p ,
278: pa_project_types pt ,
279: pa_budget_by_pa_period_v bpa ,
280: pa_implementations i ,
281: pa_class_categories cc ,
282: pa_project_classes pc

Line 334: , pa_project_types pt

330: , 0 ACT_REVENUE
331: , 0 BUD_COST
332: , 0 BUD_REVENUE
333: FROM pa_projects p
334: , pa_project_types pt
335: , pa_implementations i
336: , gl_period_statuses per
337: , pa_class_categories cc
338: , pa_project_classes pc

Line 365: , pa_project_types pt

361: , TA.TOT_REVENUE ACT_REVENUE
362: , 0 BUD_COST
363: , 0 BUD_REVENUE
364: FROM pa_projects p
365: , pa_project_types pt
366: , pa_txn_accum ta
367: , pa_implementations i
368: , gl_period_statuses per
369: , pa_class_categories cc

Line 399: , pa_project_types pt

395: , 0 ACT_REVENUE
396: , BPA.BASE_BURDENED_COST BUD_COST
397: , BPA.BASE_REVENUE BUD_REVENUE
398: FROM pa_projects p
399: , pa_project_types pt
400: , pa_budget_by_pa_period_v bpa
401: , pa_implementations I
402: , gl_period_statuses per
403: , pa_class_categories cc

Line 469: , pa_project_types pt

465: , TA.TOT_REVENUE ACT_REVENUE
466: , 0 BUD_COST
467: , 0 BUD_REVENUE
468: FROM pa_projects p
469: , pa_project_types pt
470: , pa_txn_accum ta
471: , pa_implementations i
472: , pa_periods per
473: WHERE i.accumulation_period_type = 'PA'

Line 491: , pa_project_types pt

487: , 0 ACT_REVENUE
488: , BPA.BASE_BURDENED_COST BUD_COST
489: , BPA.BASE_REVENUE BUD_REVENUE
490: FROM pa_projects p
491: , pa_project_types pt
492: , pa_budget_by_pa_period_v bpa
493: , pa_implementations i
494: WHERE i.accumulation_period_type = 'PA'
495: AND p.project_type = pt.project_type

Line 531: , pa_project_types pt

527: , TA.TOT_REVENUE ACT_REVENUE
528: , 0 BUD_COST
529: , 0 BUD_REVENUE
530: FROM pa_projects p
531: , pa_project_types pt
532: , pa_txn_accum ta
533: , pa_implementations i
534: , gl_period_statuses per
535: WHERE i.accumulation_period_type = 'GL'

Line 557: , pa_project_types pt

553: , 0 ACT_REVENUE
554: , BPA.BASE_BURDENED_COST BUD_COST
555: , BPA.BASE_REVENUE BUD_REVENUE
556: FROM pa_projects p
557: , pa_project_types pt
558: , pa_budget_by_pa_period_v bpa
559: , pa_implementations i
560: , gl_period_statuses per
561: WHERE i.accumulation_period_type = 'GL'

Line 879: , pa_project_types pt

875: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
876: , SUM(NVL(PAA.REVENUE_YTD, 0))
877: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
878: FROM pa_projects p
879: , pa_project_types pt
880: , pa_project_accum_headers pah
881: , pa_project_accum_actuals paa
882: , pa_project_accum_budgets pab
883: , pa_class_categories cc

Line 913: , pa_project_types pt

909: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
910: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
911: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
912: FROM pa_projects p
913: , pa_project_types pt
914: , pa_project_accum_headers pah
915: , pa_project_accum_actuals paa
916: , pa_project_accum_budgets pab
917: , pa_class_categories cc

Line 947: , pa_project_types pt

943: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
944: , SUM(NVL(PAA.REVENUE_YTD, 0))
945: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
946: FROM pa_projects p
947: , pa_project_types pt
948: , pa_project_accum_headers pah
949: , pa_project_accum_actuals paa
950: , pa_project_accum_budgets pab
951: , pa_class_categories cc

Line 982: , pa_project_types pt

978: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
979: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
980: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
981: FROM pa_projects p
982: , pa_project_types pt
983: , pa_project_accum_headers pah
984: , pa_project_accum_actuals paa
985: , pa_project_accum_budgets pab
986: , pa_class_categories cc

Line 1035: , pa_project_types pt

1031: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
1032: , SUM(NVL(PAA.REVENUE_YTD, 0))
1033: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
1034: FROM pa_projects p
1035: , pa_project_types pt
1036: , pa_project_accum_headers pah
1037: , pa_project_accum_actuals paa
1038: , pa_project_accum_budgets pab
1039: WHERE p.project_id = pah.project_id

Line 1063: , pa_project_types pt

1059: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
1060: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
1061: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
1062: FROM pa_projects p
1063: , pa_project_types pt
1064: , pa_project_accum_headers pah
1065: , pa_project_accum_actuals paa
1066: , pa_project_accum_budgets pab
1067: WHERE p.project_id = pah.project_id

Line 1105: , pa_project_types pt

1101: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
1102: , SUM(NVL(PAA.REVENUE_YTD, 0))
1103: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
1104: FROM pa_projects p
1105: , pa_project_types pt
1106: , pa_project_accum_headers pah
1107: , pa_project_accum_actuals paa
1108: , pa_project_accum_budgets pab
1109: , pa_organizations_proj_all_bg_v op

Line 1132: , pa_project_types pt

1128: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
1129: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
1130: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
1131: FROM pa_projects p
1132: , pa_project_types pt
1133: , pa_project_accum_headers pah
1134: , pa_project_accum_actuals paa
1135: , pa_project_accum_budgets pab
1136: , pa_organizations_proj_all_bg_v op

Line 1178: , pa_project_types pt

1174: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
1175: , SUM(NVL(PAA.REVENUE_YTD, 0))
1176: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
1177: FROM pa_projects p
1178: , pa_project_types pt
1179: , pa_project_accum_headers pah
1180: , pa_project_accum_actuals paa
1181: , pa_project_accum_budgets pab
1182: , pa_class_categories cc

Line 1209: , pa_project_types pt

1205: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
1206: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
1207: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
1208: FROM pa_projects p
1209: , pa_project_types pt
1210: , pa_project_accum_headers pah
1211: , pa_project_accum_actuals paa
1212: , pa_project_accum_budgets pab
1213: , pa_class_categories cc

Line 1240: , pa_project_types pt

1236: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
1237: , SUM(NVL(PAA.REVENUE_YTD, 0))
1238: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
1239: FROM pa_projects p
1240: , pa_project_types pt
1241: , pa_project_accum_headers pah
1242: , pa_project_accum_actuals paa
1243: , pa_project_accum_budgets pab
1244: , pa_class_categories cc

Line 1272: , pa_project_types pt

1268: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
1269: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
1270: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
1271: FROM pa_projects p
1272: , pa_project_types pt
1273: , pa_project_accum_headers pah
1274: , pa_project_accum_actuals paa
1275: , pa_project_accum_budgets pab
1276: , pa_class_categories cc

Line 1369: , pa_project_types pt

1365: , SUM(NVL(PAB.BASE_REVENUE_PTD, 0))
1366: , SUM(NVL(PAA.REVENUE_YTD, 0))
1367: , SUM(NVL(PAB.BASE_REVENUE_YTD, 0))
1368: FROM pa_projects p
1369: , pa_project_types pt
1370: , pa_project_accum_headers pah
1371: , pa_project_accum_actuals paa
1372: , pa_project_accum_budgets pab
1373: WHERE p.project_id = pah.project_id

Line 1393: , pa_project_types pt

1389: , SUM(NVL(PAB.BASE_BURDENED_COST_PTD, 0))
1390: , SUM(NVL(PAA.BURDENED_COST_YTD, 0))
1391: , SUM(NVL(PAB.BASE_BURDENED_COST_YTD, 0))
1392: FROM pa_projects p
1393: , pa_project_types pt
1394: , pa_project_accum_headers pah
1395: , pa_project_accum_actuals paa
1396: , pa_project_accum_budgets pab
1397: WHERE p.project_id = pah.project_id