eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GL_BC_PACKETS_V

Object Details

Object Name:	GL_BC_PACKETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_BC_PACKETS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
PACKET_ID	NUMBER	(15)	Yes
SET_OF_BOOKS_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	VARCHAR2	(40)
ACCOUNTED_CR	VARCHAR2	(40)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
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	VARCHAR2	(40)
ACTUAL_POSTED_BALANCE	VARCHAR2	(40)
ENC_POSTED_BALANCE	VARCHAR2	(40)
BUDGET_APPROVED_BALANCE	VARCHAR2	(40)
ACTUAL_APPROVED_BALANCE	VARCHAR2	(40)
ENC_APPROVED_BALANCE	VARCHAR2	(40)
BUDGET_PENDING_BALANCE	VARCHAR2	(40)
ACTUAL_PENDING_BALANCE	VARCHAR2	(40)
ENC_PENDING_BALANCE	VARCHAR2	(40)
BUDGET_TOTAL_BALANCE	VARCHAR2	(40)
ENC_TOTAL_BALANCE	VARCHAR2	(40)
ACTUAL_TOTAL_BALANCE	VARCHAR2	(40)
AVAIL_POSTED_BALANCE	VARCHAR2	(40)
AVAIL_APPROVED_BALANCE	VARCHAR2	(40)
AVAIL_PENDING_BALANCE	VARCHAR2	(40)
AVAIL_TOTAL_BALANCE	VARCHAR2	(40)
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)
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Yes
USER_JE_SOURCE_NAME	VARCHAR2	(25)	Yes
TRANSACTION_AMOUNT	NUMBER
ACTUAL_FLAG_MEANING	VARCHAR2	(240)
BUDGET_NAME	VARCHAR2	(15)
ENCUMBRANCE_TYPE	VARCHAR2	(30)
STATUS_CODE_MEANING	VARCHAR2	(80)	Yes
RESULT_CODE_MEANING	VARCHAR2	(240)
FUNDING_BUDGET_NAME	VARCHAR2	(15)
AMOUNT_TYPE_MEANING	VARCHAR2	(80)
BOUNDARY_MEANING	VARCHAR2	(80)
TEMPLATE	VARCHAR2	(240)
LEVEL_MEANING	VARCHAR2	(80)
ACCOUNT_TYPE_MEANING	VARCHAR2	(240)
EFFECT_ON_FUNDS_MEANING	VARCHAR2	(80)
BATCH_NAME	VARCHAR2	(100)
HEADER_NAME	VARCHAR2	(100)

Query Text

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


SELECT ROW_ID
,      PACKET_ID
,      SET_OF_BOOKS_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
,      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
,      ENC_POSTED_BALANCE
,      BUDGET_APPROVED_BALANCE
,      ACTUAL_APPROVED_BALANCE
,      ENC_APPROVED_BALANCE
,      BUDGET_PENDING_BALANCE
,      ACTUAL_PENDING_BALANCE
,      ENC_PENDING_BALANCE
,      BUDGET_TOTAL_BALANCE
,      ENC_TOTAL_BALANCE
,      ACTUAL_TOTAL_BALANCE
,      AVAIL_POSTED_BALANCE
,      AVAIL_APPROVED_BALANCE
,      AVAIL_PENDING_BALANCE
,      AVAIL_TOTAL_BALANCE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      JE_BATCH_NAME
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      JE_LINE_DESCRIPTION
,      USER_JE_CATEGORY_NAME
,      USER_JE_SOURCE_NAME
,      TRANSACTION_AMOUNT
,      ACTUAL_FLAG_MEANING
,      BUDGET_NAME
,      ENCUMBRANCE_TYPE
,      STATUS_CODE_MEANING
,      RESULT_CODE_MEANING
,      FUNDING_BUDGET_NAME
,      AMOUNT_TYPE_MEANING
,      BOUNDARY_MEANING
,      TEMPLATE
,      LEVEL_MEANING
,      ACCOUNT_TYPE_MEANING
,      EFFECT_ON_FUNDS_MEANING
,      BATCH_NAME
,      HEADER_NAME
FROM APPS.GL_BC_PACKETS_V;

Dependencies

[top of page]

APPS.GL_BC_PACKETS_V references the following:

APPS: GL_BC_PACKETS; GL_BUDGET_VERSIONS; GL_ENCUMBRANCE_TYPES; GL_JE_BATCHES; GL_JE_CATEGORIES; GL_JE_HEADERS; GL_JE_SOURCES; GL_LOOKUPS; GL_SUMMARY_TEMPLATES

APPS.GL_BC_PACKETS_V is not referenced by any database object