DBA Data[Home] [Help] [Dependency Information]

VIEW: GMS.GMS_BC_PACKETS#

Object Details
Object Name: GMS_BC_PACKETS#
Object Type: VIEW
Owner: GMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
AWARD_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
EXPENDITURE_ITEM_DATE DATE
Yes
ACTUAL_FLAG VARCHAR2 (1) Yes
STATUS_CODE VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
JE_CATEGORY_NAME VARCHAR2 (30) Yes
JE_SOURCE_NAME VARCHAR2 (30) Yes
TRANSFERED_FLAG VARCHAR2 (1) Yes
DOCUMENT_TYPE VARCHAR2 (3) Yes
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
PERIOD_NAME VARCHAR2 (15)
PERIOD_YEAR NUMBER (15)
PERIOD_NUM NUMBER (15)
DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
TOP_TASK_ID NUMBER (15)
PARENT_RESOURCE_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
ACCOUNT_TYPE VARCHAR2 (1)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

TOLERANCE_AMOUNT NUMBER

TOLERANCE_PERCENTAGE NUMBER

OVERRIDE_AMOUNT NUMBER

EFFECT_ON_FUNDS_CODE VARCHAR2 (1)
RESULT_CODE VARCHAR2 (3)
GL_BC_PACKETS_ROWID VARCHAR2 (30)
AWARD_BUDGET_POSTED NUMBER

AWARD_BUDGET_APPROVED NUMBER

AWARD_BUDGET_PENDING NUMBER

AWARD_ENC_POSTED NUMBER

AWARD_ENC_APPROVED NUMBER

AWARD_ENC_PENDING NUMBER

AWARD_ACTUAL_POSTED NUMBER

AWARD_ACTUAL_APPROVED NUMBER

AWARD_ACTUAL_PENDING NUMBER

AWARD_RESULT_CODE VARCHAR2 (3)
TASK_BUDGET_POSTED NUMBER

TASK_BUDGET_APPROVED NUMBER

TASK_BUDGET_PENDING NUMBER

TASK_ENC_POSTED NUMBER

TASK_ENC_APPROVED NUMBER

TASK_ENC_PENDING NUMBER

TASK_ACTUAL_POSTED NUMBER

TASK_ACTUAL_APPROVED NUMBER

TASK_ACTUAL_PENDING NUMBER

TASK_RESULT_CODE VARCHAR2 (3)
RES_GRP_BUDGET_POSTED NUMBER

RES_GRP_BUDGET_APPROVED NUMBER

RES_GRP_BUDGET_PENDING NUMBER

RES_GRP_ENC_POSTED NUMBER

RES_GRP_ENC_APPROVED NUMBER

RES_GRP_ENC_PENDING NUMBER

RES_GRP_ACTUAL_POSTED NUMBER

RES_GRP_ACTUAL_APPROVED NUMBER

RES_GRP_ACTUAL_PENDING NUMBER

RES_GRP_RESULT_CODE VARCHAR2 (3)
RES_BUDGET_POSTED NUMBER

RES_BUDGET_APPROVED NUMBER

RES_BUDGET_PENDING NUMBER

RES_ENC_POSTED NUMBER

RES_ENC_APPROVED NUMBER

RES_ENC_PENDING NUMBER

RES_ACTUAL_POSTED NUMBER

RES_ACTUAL_APPROVED NUMBER

RES_ACTUAL_PENDING NUMBER

RES_RESULT_CODE VARCHAR2 (3)
STATUS_FLAG VARCHAR2 (2)
RES_BUDGET_BAL NUMBER

RES_GRP_BUDGET_BAL NUMBER

TASK_BUDGET_BAL NUMBER

TOP_TASK_BUDGET_BAL NUMBER

AWARD_BUDGET_BAL NUMBER

GL_ROW_NUMBER NUMBER

BC_PACKET_ID NUMBER

PARENT_BC_PACKET_ID NUMBER

BURDENABLE_RAW_COST NUMBER

BUD_RESOURCE_LIST_MEMBER_ID NUMBER (15)
BUD_TASK_ID NUMBER (15)
FUNDING_PATTERN_ID NUMBER (15)
FUNDING_SEQUENCE NUMBER (15)
FP_STATUS VARCHAR2 (1)
R_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
RG_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
T_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
TT_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
A_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
TOP_TASK_BUDGET_POSTED NUMBER

TOP_TASK_BUDGET_APPROVED NUMBER

TOP_TASK_BUDGET_PENDING NUMBER

TOP_TASK_ENC_POSTED NUMBER

TOP_TASK_ENC_APPROVED NUMBER

TOP_TASK_ENC_PENDING NUMBER

TOP_TASK_ACTUAL_POSTED NUMBER

TOP_TASK_ACTUAL_APPROVED NUMBER

TOP_TASK_ACTUAL_PENDING NUMBER

TOP_TASK_RESULT_CODE VARCHAR2 (3)
REQUEST_ID NUMBER (15)
BALANCE_POSTED_FLAG VARCHAR2 (1)
BURDEN_POSTED_FLAG VARCHAR2 (1)
BURDENED_COST NUMBER (22)
FUNDS_CHECK_SEQ NUMBER (15)
AMOUNT_TYPE VARCHAR2 (4)
BOUNDARY_CODE VARCHAR2 (2)
BUDGET_PERIOD_START_DATE DATE

BUDGET_PERIOD_END_DATE DATE

CATEGORIZATION_CODE VARCHAR2 (30)
PARENT_TASK_ID NUMBER (15)
RESOURCE_LIST_ID NUMBER (15)
TIME_PHASED_TYPE_CODE VARCHAR2 (1)
BUDGETED_AT_RESOURCE_LEVEL VARCHAR2 (1)
FC_ERROR_MESSAGE VARCHAR2 (2000)
IND_COMPILED_SET_ID NUMBER (15)
PERSON_ID NUMBER (9)
JOB_ID NUMBER (15)
VENDOR_ID NUMBER (15)
EXPENDITURE_CATEGORY VARCHAR2 (30)
REVENUE_CATEGORY VARCHAR2 (30)
ADJUSTED_DOCUMENT_HEADER_ID NUMBER (15)
AWARD_SET_ID NUMBER (15)
TRANSACTION_SOURCE VARCHAR2 (30)
BURDEN_ADJUSTMENT_FLAG VARCHAR2 (1)
BURDEN_ADJ_BC_PACKET_ID NUMBER

BURDEN_CALCULATION_SEQ NUMBER

TXN_INTERFACE_ID NUMBER (15)
SESSION_ID NUMBER (38)
SERIAL_ID NUMBER (38)
SOURCE_EVENT_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PACKET_ID
,      PROJECT_ID
,      AWARD_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      ACTUAL_FLAG
,      STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      TRANSFERED_FLAG
,      DOCUMENT_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      TOP_TASK_ID
,      PARENT_RESOURCE_ID
,      BUDGET_VERSION_ID
,      RESOURCE_LIST_MEMBER_ID
,      ACCOUNT_TYPE
,      ENTERED_DR
,      ENTERED_CR
,      TOLERANCE_AMOUNT
,      TOLERANCE_PERCENTAGE
,      OVERRIDE_AMOUNT
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      GL_BC_PACKETS_ROWID
,      AWARD_BUDGET_POSTED
,      AWARD_BUDGET_APPROVED
,      AWARD_BUDGET_PENDING
,      AWARD_ENC_POSTED
,      AWARD_ENC_APPROVED
,      AWARD_ENC_PENDING
,      AWARD_ACTUAL_POSTED
,      AWARD_ACTUAL_APPROVED
,      AWARD_ACTUAL_PENDING
,      AWARD_RESULT_CODE
,      TASK_BUDGET_POSTED
,      TASK_BUDGET_APPROVED
,      TASK_BUDGET_PENDING
,      TASK_ENC_POSTED
,      TASK_ENC_APPROVED
,      TASK_ENC_PENDING
,      TASK_ACTUAL_POSTED
,      TASK_ACTUAL_APPROVED
,      TASK_ACTUAL_PENDING
,      TASK_RESULT_CODE
,      RES_GRP_BUDGET_POSTED
,      RES_GRP_BUDGET_APPROVED
,      RES_GRP_BUDGET_PENDING
,      RES_GRP_ENC_POSTED
,      RES_GRP_ENC_APPROVED
,      RES_GRP_ENC_PENDING
,      RES_GRP_ACTUAL_POSTED
,      RES_GRP_ACTUAL_APPROVED
,      RES_GRP_ACTUAL_PENDING
,      RES_GRP_RESULT_CODE
,      RES_BUDGET_POSTED
,      RES_BUDGET_APPROVED
,      RES_BUDGET_PENDING
,      RES_ENC_POSTED
,      RES_ENC_APPROVED
,      RES_ENC_PENDING
,      RES_ACTUAL_POSTED
,      RES_ACTUAL_APPROVED
,      RES_ACTUAL_PENDING
,      RES_RESULT_CODE
,      STATUS_FLAG
,      RES_BUDGET_BAL
,      RES_GRP_BUDGET_BAL
,      TASK_BUDGET_BAL
,      TOP_TASK_BUDGET_BAL
,      AWARD_BUDGET_BAL
,      GL_ROW_NUMBER
,      BC_PACKET_ID
,      PARENT_BC_PACKET_ID
,      BURDENABLE_RAW_COST
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      FUNDING_PATTERN_ID
,      FUNDING_SEQUENCE
,      FP_STATUS
,      R_FUNDS_CONTROL_LEVEL_CODE
,      RG_FUNDS_CONTROL_LEVEL_CODE
,      T_FUNDS_CONTROL_LEVEL_CODE
,      TT_FUNDS_CONTROL_LEVEL_CODE
,      A_FUNDS_CONTROL_LEVEL_CODE
,      TOP_TASK_BUDGET_POSTED
,      TOP_TASK_BUDGET_APPROVED
,      TOP_TASK_BUDGET_PENDING
,      TOP_TASK_ENC_POSTED
,      TOP_TASK_ENC_APPROVED
,      TOP_TASK_ENC_PENDING
,      TOP_TASK_ACTUAL_POSTED
,      TOP_TASK_ACTUAL_APPROVED
,      TOP_TASK_ACTUAL_PENDING
,      TOP_TASK_RESULT_CODE
,      REQUEST_ID
,      BALANCE_POSTED_FLAG
,      BURDEN_POSTED_FLAG
,      BURDENED_COST
,      FUNDS_CHECK_SEQ
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      BUDGET_PERIOD_START_DATE
,      BUDGET_PERIOD_END_DATE
,      CATEGORIZATION_CODE
,      PARENT_TASK_ID
,      RESOURCE_LIST_ID
,      TIME_PHASED_TYPE_CODE
,      BUDGETED_AT_RESOURCE_LEVEL
,      FC_ERROR_MESSAGE
,      IND_COMPILED_SET_ID
,      PERSON_ID
,      JOB_ID
,      VENDOR_ID
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      ADJUSTED_DOCUMENT_HEADER_ID
,      AWARD_SET_ID
,      TRANSACTION_SOURCE
,      BURDEN_ADJUSTMENT_FLAG
,      BURDEN_ADJ_BC_PACKET_ID
,      BURDEN_CALCULATION_SEQ
,      TXN_INTERFACE_ID
,      SESSION_ID
,      SERIAL_ID
,      SOURCE_EVENT_ID
FROM GMS.GMS_BC_PACKETS#;

Dependencies

[top of page]

GMS.GMS_BC_PACKETS# references the following:

SchemaGMS
TableGMS_BC_PACKETS
GMS.GMS_BC_PACKETS# is referenced by following:

SchemaAPPS
SynonymGMS_BC_PACKETS