VIEW: OZF.OZF_ACT_BUDGETS#

Source

View Text - Preformatted

select ACTIVITY_BUDGET_ID ACTIVITY_BUDGET_ID, RECAL_FLAG RECAL_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACT_BUDGET_USED_BY_ID ACT_BUDGET_USED_BY_ID, ARC_ACT_BUDGET_USED_BY ARC_ACT_BUDGET_USED_BY, BUDGET_SOURCE_TYPE BUDGET_SOURCE_TYPE, BUDGET_SOURCE_ID BUDGET_SOURCE_ID, TRANSACTION_TYPE TRANSACTION_TYPE, REQUEST_AMOUNT REQUEST_AMOUNT, REQUEST_CURRENCY REQUEST_CURRENCY, REQUEST_DATE REQUEST_DATE, USER_STATUS_ID USER_STATUS_ID, STATUS_CODE STATUS_CODE, APPROVED_AMOUNT APPROVED_AMOUNT, APPROVED_ORIGINAL_AMOUNT APPROVED_ORIGINAL_AMOUNT, APPROVED_IN_CURRENCY APPROVED_IN_CURRENCY, APPROVAL_DATE APPROVAL_DATE, DATE_REQUIRED_BY DATE_REQUIRED_BY, APPROVER_ID APPROVER_ID, REQUESTER_ID REQUESTER_ID, APPROVED_AMOUNT_FC APPROVED_AMOUNT_FC, SPENT_AMOUNT SPENT_AMOUNT, PARTNER_PO_NUMBER PARTNER_PO_NUMBER, PARTNER_PO_DATE PARTNER_PO_DATE, PARTNER_PO_APPROVER PARTNER_PO_APPROVER, POSTED_FLAG POSTED_FLAG, ADJUSTED_FLAG ADJUSTED_FLAG, CONTACT_ID CONTACT_ID, PARENT_ACT_BUDGET_ID PARENT_ACT_BUDGET_ID, PARENT_SOURCE_ID PARENT_SOURCE_ID, PARENT_SRC_CURR PARENT_SRC_CURR, PARENT_SRC_APPRVD_AMT PARENT_SRC_APPRVD_AMT, REASON_CODE REASON_CODE, TRANSFER_TYPE TRANSFER_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, VENDOR_ID VENDOR_ID, PARTNER_HOLDING_TYPE PARTNER_HOLDING_TYPE, PARTNER_ADDRESS_ID PARTNER_ADDRESS_ID, OWNER_ID OWNER_ID, SRC_CURR_REQUEST_AMT SRC_CURR_REQUEST_AMT from "OZF"."OZF_ACT_BUDGETS"

View Text - HTML Formatted

SELECT ACTIVITY_BUDGET_ID ACTIVITY_BUDGET_ID
, RECAL_FLAG RECAL_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACT_BUDGET_USED_BY_ID ACT_BUDGET_USED_BY_ID
, ARC_ACT_BUDGET_USED_BY ARC_ACT_BUDGET_USED_BY
, BUDGET_SOURCE_TYPE BUDGET_SOURCE_TYPE
, BUDGET_SOURCE_ID BUDGET_SOURCE_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, REQUEST_AMOUNT REQUEST_AMOUNT
, REQUEST_CURRENCY REQUEST_CURRENCY
, REQUEST_DATE REQUEST_DATE
, USER_STATUS_ID USER_STATUS_ID
, STATUS_CODE STATUS_CODE
, APPROVED_AMOUNT APPROVED_AMOUNT
, APPROVED_ORIGINAL_AMOUNT APPROVED_ORIGINAL_AMOUNT
, APPROVED_IN_CURRENCY APPROVED_IN_CURRENCY
, APPROVAL_DATE APPROVAL_DATE
, DATE_REQUIRED_BY DATE_REQUIRED_BY
, APPROVER_ID APPROVER_ID
, REQUESTER_ID REQUESTER_ID
, APPROVED_AMOUNT_FC APPROVED_AMOUNT_FC
, SPENT_AMOUNT SPENT_AMOUNT
, PARTNER_PO_NUMBER PARTNER_PO_NUMBER
, PARTNER_PO_DATE PARTNER_PO_DATE
, PARTNER_PO_APPROVER PARTNER_PO_APPROVER
, POSTED_FLAG POSTED_FLAG
, ADJUSTED_FLAG ADJUSTED_FLAG
, CONTACT_ID CONTACT_ID
, PARENT_ACT_BUDGET_ID PARENT_ACT_BUDGET_ID
, PARENT_SOURCE_ID PARENT_SOURCE_ID
, PARENT_SRC_CURR PARENT_SRC_CURR
, PARENT_SRC_APPRVD_AMT PARENT_SRC_APPRVD_AMT
, REASON_CODE REASON_CODE
, TRANSFER_TYPE TRANSFER_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, VENDOR_ID VENDOR_ID
, PARTNER_HOLDING_TYPE PARTNER_HOLDING_TYPE
, PARTNER_ADDRESS_ID PARTNER_ADDRESS_ID
, OWNER_ID OWNER_ID
, SRC_CURR_REQUEST_AMT SRC_CURR_REQUEST_AMT
FROM "OZF"."OZF_ACT_BUDGETS"