DBA Data[Home] [Help]

APPS.PA_BIS_SUMMARY dependencies on PA_PROJECT_ACCUM_ACTUALS

Line 881: , pa_project_accum_actuals paa

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

Line 915: , pa_project_accum_actuals paa

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

Line 949: , pa_project_accum_actuals paa

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

Line 984: , pa_project_accum_actuals paa

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

Line 1037: , pa_project_accum_actuals paa

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
1041: AND pt.project_type_class_code = 'CONTRACT'

Line 1065: , pa_project_accum_actuals paa

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
1069: AND pt.project_type_class_code = 'CONTRACT'

Line 1107: , pa_project_accum_actuals paa

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

Line 1134: , pa_project_accum_actuals paa

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

Line 1180: , pa_project_accum_actuals paa

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

Line 1211: , pa_project_accum_actuals paa

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

Line 1242: , pa_project_accum_actuals paa

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

Line 1274: , pa_project_accum_actuals paa

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

Line 1371: , pa_project_accum_actuals paa

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
1375: AND pt.project_type_class_code = 'CONTRACT'

Line 1395: , pa_project_accum_actuals paa

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
1399: AND pt.project_type_class_code = 'CONTRACT'