Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_STATUS_PROJ_GENERIC_V |
SELECT "PROJECT_ID"
, "VIEW_LABOR_COSTS_ALLOWED"
, "COST_BUDGET_TYPE_CODE"
, "REV_BUDGET_TYPE_CODE"
, "COLUMN1"
, "COLUMN2"
, "COLUMN3"
, "COLUMN4"
, "COLUMN5"
, "COLUMN6"
, "COLUMN7"
, "COLUMN8"
, "COLUMN9"
, "COLUMN10"
, "COLUMN11"
, "COLUMN12"
, "COLUMN13"
, "COLUMN14"
, "COLUMN15"
, "COLUMN16"
, "COLUMN17"
, "COLUMN18"
, "COLUMN19"
, "COLUMN20"
, "COLUMN21"
, "COLUMN22"
, "COLUMN23"
, "COLUMN24"
, "COLUMN25"
, "COLUMN26"
, "COLUMN27"
, "COLUMN28"
, "COLUMN29"
, "COLUMN30"
, "COLUMN31"
, "COLUMN32"
, "COLUMN33"
FROM PA_STATUS_PROJ_GENERIC_V A
WHERE NOT EXISTS ( SELECT 1
FROM PA_PROJECTS B
WHERE A.PROJECT_ID = B.PROJECT_ID
AND B.PROJECT_TYPE = 'AWARD_PROJECT')