Skip to content

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

VIEW: GL.GL_BC_PACKETS_HISTS#

Object Details
Object Name: GL_BC_PACKETS_HISTS#
Object Type: VIEW
Owner: GL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER (15) Yes
LEDGER_ID NUMBER (15) Yes
JE_SOURCE_NAME VARCHAR2 (25) Yes
JE_CATEGORY_NAME VARCHAR2 (25) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
ACTUAL_FLAG VARCHAR2 (1) Yes
PERIOD_NAME VARCHAR2 (15) Yes
PERIOD_YEAR NUMBER (15) Yes
PERIOD_NUM NUMBER (15) Yes
QUARTER_NUM NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
STATUS_CODE VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
BUDGET_VERSION_ID NUMBER (15)
ENCUMBRANCE_TYPE_ID NUMBER (15)
TEMPLATE_ID NUMBER (15)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

USSGL_TRANSACTION_CODE VARCHAR2 (30)
ORIGINATING_ROWID ROWID (10)
ACCOUNT_SEGMENT_VALUE VARCHAR2 (25)
AUTOMATIC_ENCUMBRANCE_FLAG VARCHAR2 (1)
FUNDING_BUDGET_VERSION_ID NUMBER (15)
FUNDS_CHECK_LEVEL_CODE VARCHAR2 (1)
AMOUNT_TYPE VARCHAR2 (4)
BOUNDARY_CODE VARCHAR2 (1)
TOLERANCE_PERCENTAGE NUMBER

TOLERANCE_AMOUNT NUMBER

OVERRIDE_AMOUNT NUMBER

DR_CR_CODE VARCHAR2 (1)
ACCOUNT_TYPE VARCHAR2 (1)
ACCOUNT_CATEGORY_CODE VARCHAR2 (1)
EFFECT_ON_FUNDS_CODE VARCHAR2 (1)
RESULT_CODE VARCHAR2 (3)
BUDGET_POSTED_BALANCE NUMBER

ACTUAL_POSTED_BALANCE NUMBER

ENCUMBRANCE_POSTED_BALANCE NUMBER

BUDGET_APPROVED_BALANCE NUMBER

ACTUAL_APPROVED_BALANCE NUMBER

ENCUMBRANCE_APPROVED_BALANCE NUMBER

BUDGET_PENDING_BALANCE NUMBER

ACTUAL_PENDING_BALANCE NUMBER

ENCUMBRANCE_PENDING_BALANCE NUMBER

REFERENCE1 VARCHAR2 (100)
REFERENCE2 VARCHAR2 (100)
REFERENCE3 VARCHAR2 (100)
REFERENCE4 VARCHAR2 (100)
REFERENCE5 VARCHAR2 (100)
JE_BATCH_NAME VARCHAR2 (100)
JE_BATCH_ID NUMBER (15)
JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
JE_LINE_DESCRIPTION VARCHAR2 (240)
REFERENCE6 VARCHAR2 (100)
REFERENCE7 VARCHAR2 (100)
REFERENCE8 VARCHAR2 (100)
REFERENCE9 VARCHAR2 (100)
REFERENCE10 VARCHAR2 (100)
REFERENCE11 VARCHAR2 (100)
REFERENCE12 VARCHAR2 (100)
REFERENCE13 VARCHAR2 (100)
REFERENCE14 VARCHAR2 (100)
REFERENCE15 VARCHAR2 (100)
REQUEST_ID NUMBER (15)
USSGL_PARENT_ID NUMBER (15)
EVENT_ID NUMBER (15)
AE_HEADER_ID NUMBER (15)
AE_LINE_NUM NUMBER (15)
BC_DATE DATE

SOURCE_DISTRIBUTION_TYPE VARCHAR2 (30)
SOURCE_DISTRIBUTION_ID_CHAR_1 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_2 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_3 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_4 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_5 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_NUM_1 NUMBER (38)
SOURCE_DISTRIBUTION_ID_NUM_2 NUMBER (38)
SOURCE_DISTRIBUTION_ID_NUM_3 NUMBER (38)
SOURCE_DISTRIBUTION_ID_NUM_4 NUMBER (38)
SOURCE_DISTRIBUTION_ID_NUM_5 NUMBER (38)
SESSION_ID NUMBER (38) Yes
SERIAL_ID NUMBER (38) Yes
APPLICATION_ID NUMBER (15) Yes
ENTITY_ID NUMBER (15)
GROUP_ID NUMBER (15)
Query Text

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


SELECT PACKET_ID
,      LEDGER_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      CODE_COMBINATION_ID
,      ACTUAL_FLAG
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      CURRENCY_CODE
,      STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      TEMPLATE_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      USSGL_TRANSACTION_CODE
,      ORIGINATING_ROWID
,      ACCOUNT_SEGMENT_VALUE
,      AUTOMATIC_ENCUMBRANCE_FLAG
,      FUNDING_BUDGET_VERSION_ID
,      FUNDS_CHECK_LEVEL_CODE
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      TOLERANCE_PERCENTAGE
,      TOLERANCE_AMOUNT
,      OVERRIDE_AMOUNT
,      DR_CR_CODE
,      ACCOUNT_TYPE
,      ACCOUNT_CATEGORY_CODE
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      BUDGET_POSTED_BALANCE
,      ACTUAL_POSTED_BALANCE
,      ENCUMBRANCE_POSTED_BALANCE
,      BUDGET_APPROVED_BALANCE
,      ACTUAL_APPROVED_BALANCE
,      ENCUMBRANCE_APPROVED_BALANCE
,      BUDGET_PENDING_BALANCE
,      ACTUAL_PENDING_BALANCE
,      ENCUMBRANCE_PENDING_BALANCE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      JE_BATCH_NAME
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      JE_LINE_DESCRIPTION
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REQUEST_ID
,      USSGL_PARENT_ID
,      USSGL_LINK_TO_PARENT_ID
,      EVENT_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      BC_DATE
,      SOURCE_DISTRIBUTION_TYPE
,      SOURCE_DISTRIBUTION_ID_CHAR_1
,      SOURCE_DISTRIBUTION_ID_CHAR_2
,      SOURCE_DISTRIBUTION_ID_CHAR_3
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
,      SESSION_ID
,      SERIAL_ID
,      APPLICATION_ID
,      ENTITY_ID
,      GROUP_ID
FROM GL.GL_BC_PACKETS_HISTS#;

Dependencies

[top of page]

GL.GL_BC_PACKETS_HISTS# references the following:

SchemaGL
TableGL_BC_PACKETS_HISTS
GL.GL_BC_PACKETS_HISTS# is referenced by following:

SchemaAPPS
SynonymGL_BC_PACKETS_HISTS