Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AWARD_ID
, AWARD_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, AWARD_SHORT_NAME
, AWARD_FULL_NAME
, FUNDING_SOURCE_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CLOSE_DATE
, FUNDING_SOURCE_AWARD_NUMBER
, AWARD_PURPOSE_CODE
, STATUS
, ALLOWABLE_SCHEDULE_ID
, IDC_SCHEDULE_ID
, REVENUE_DISTRIBUTION_RULE
, BILLING_FREQUENCY
, BILLING_CYCLE_ID
, BILLING_OFFSET
, BILLING_DISTRIBUTION_RULE
, BILLING_FORMAT
, BILLING_TERM
, AWARD_PROJECT_ID
, AGREEMENT_ID
, AWARD_TEMPLATE_FLAG
, PREAWARD_DATE
, AWARD_MANAGER_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, AGENCY_SPECIFIC_FORM
, BILL_TO_CUSTOMER_ID
, TRANSACTION_NUMBER
, AMOUNT_TYPE
, BOUNDARY_CODE
, FUND_CONTROL_LEVEL_AWARD
, FUND_CONTROL_LEVEL_TASK
, FUND_CONTROL_LEVEL_RES_GRP
, FUND_CONTROL_LEVEL_RES
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TEMPLATE_START_DATE_ACTIVE
, TEMPLATE_END_DATE_ACTIVE
, TYPE
, ORG_ID
, COST_IND_SCH_FIXED_DATE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, BILL_TO_ADDRESS_ID
, SHIP_TO_ADDRESS_ID
, LOC_BILL_TO_ADDRESS_ID
, LOC_SHIP_TO_ADDRESS_ID
, AWARD_ORGANIZATION_ID
, HARD_LIMIT_FLAG
, BUDGET_WF_ENABLED_FLAG
, PROPOSAL_ID
FROM GMS_AWARDS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)