DBA Data[Home] [Help]

VIEW: GMS.GMS_BC_PACKETS_SUMMARY#

Source

View Text - Preformatted

select PACKET_ID PACKET_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, BUD_TASK_ID BUD_TASK_ID, TOP_TASK_ID TOP_TASK_ID, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID, PARENT_RESOURCE_ID PARENT_RESOURCE_ID, BUDGET_PERIOD_START_DATE BUDGET_PERIOD_START_DATE, BUDGET_PERIOD_END_DATE BUDGET_PERIOD_END_DATE, CREATION_DATE CREATION_DATE, ACTUAL_APPROVED ACTUAL_APPROVED, ACTUAL_PENDING ACTUAL_PENDING, ENC_APPROVED ENC_APPROVED, ENC_PENDING ENC_PENDING, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID from "GMS"."GMS_BC_PACKETS_SUMMARY"
View Text - HTML Formatted

SELECT PACKET_ID PACKET_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUD_TASK_ID BUD_TASK_ID
, TOP_TASK_ID TOP_TASK_ID
, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID
, PARENT_RESOURCE_ID PARENT_RESOURCE_ID
, BUDGET_PERIOD_START_DATE BUDGET_PERIOD_START_DATE
, BUDGET_PERIOD_END_DATE BUDGET_PERIOD_END_DATE
, CREATION_DATE CREATION_DATE
, ACTUAL_APPROVED ACTUAL_APPROVED
, ACTUAL_PENDING ACTUAL_PENDING
, ENC_APPROVED ENC_APPROVED
, ENC_PENDING ENC_PENDING
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
FROM "GMS"."GMS_BC_PACKETS_SUMMARY"