DBA Data[Home] [Help]

APPS.PA_BIS_SUMMARY dependencies on PA_PROJECTS

Line 42: FROM pa_projects p

38: , TA.TOT_BURDENED_COST ACT_COST
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

Line 70: FROM pa_projects p

66: , TA.TOT_BURDENED_COST ACT_COST
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

Line 94: FROM pa_projects p

90: , 0 ACT_COST
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

Line 123: FROM pa_projects p

119: , 0 ACT_COST
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'

Line 146: FROM pa_projects p

142: , 0 ACT_COST
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'

Line 171: FROM pa_projects p

167: , 0 ACT_COST
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'

Line 218: FROM pa_projects p ,

214: 0 ACT_COST,
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 ,

Line 245: pa_projects p

241: TA.TOT_REVENUE ACT_REVENUE,
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 ,

Line 277: FROM pa_projects p ,

273: 0 ACT_COST,
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 ,

Line 333: FROM pa_projects p

329: , 0 ACT_COST
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

Line 364: FROM pa_projects p

360: , TA.TOT_BURDENED_COST ACT_COST
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

Line 398: FROM pa_projects p

394: , 0 ACT_COST
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

Line 468: FROM pa_projects p

464: , TA.TOT_BURDENED_COST ACT_COST
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

Line 490: FROM pa_projects p

486: , 0 ACT_COST
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'

Line 530: FROM pa_projects p

526: , TA.TOT_BURDENED_COST ACT_COST
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

Line 556: FROM pa_projects p

552: , 0 ACT_COST
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

Line 878: FROM pa_projects p

874: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 912: FROM pa_projects p

908: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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

Line 946: FROM pa_projects p

942: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 981: FROM pa_projects p

977: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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

Line 1034: FROM pa_projects p

1030: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 1062: FROM pa_projects p

1058: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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

Line 1104: FROM pa_projects p

1100: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 1131: FROM pa_projects p

1127: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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

Line 1177: FROM pa_projects p

1173: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 1208: FROM pa_projects p

1204: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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

Line 1239: FROM pa_projects p

1235: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 1271: FROM pa_projects p

1267: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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

Line 1368: FROM pa_projects p

1364: , SUM(NVL(PAA.REVENUE_PTD, 0))
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

Line 1392: FROM pa_projects p

1388: , SUM(NVL(PAA.BURDENED_COST_PTD, 0))
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