DBA Data[Home] [Help]

APPS.PA_BIS_SUMMARY dependencies on PA_PROJECT_ACCUM_HEADERS

Line 880: , pa_project_accum_headers pah

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
884: , pa_project_classes pc

Line 914: , pa_project_accum_headers pah

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
918: , pa_project_classes pc

Line 948: , pa_project_accum_headers pah

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
952: WHERE p.project_id = pah.project_id

Line 983: , pa_project_accum_headers pah

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
987: WHERE p.project_id = pah.project_id

Line 1036: , pa_project_accum_headers pah

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
1040: AND p.project_type = pt.project_type

Line 1064: , pa_project_accum_headers pah

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
1068: AND p.project_type = pt.project_type

Line 1106: , pa_project_accum_headers pah

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
1110: WHERE p.project_id = pah.project_id

Line 1133: , pa_project_accum_headers pah

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
1137: WHERE p.project_id = pah.project_id

Line 1179: , pa_project_accum_headers pah

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
1183: , pa_project_classes pc

Line 1210: , pa_project_accum_headers pah

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
1214: , pa_project_classes pc

Line 1241: , pa_project_accum_headers pah

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
1245: WHERE p.project_id = pah.project_id

Line 1273: , pa_project_accum_headers pah

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
1277: WHERE p.project_id = pah.project_id

Line 1370: , pa_project_accum_headers pah

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
1374: AND p.project_type = pt.project_type

Line 1394: , pa_project_accum_headers pah

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
1398: AND p.project_type = pt.project_type