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]

TABLE: PA.PA_BC_PACKETS_HIST

Object Details

Object Name:	PA_BC_PACKETS_HIST
Object Type:	TABLE
Owner:	PA
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BC_PACKETS_HIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PACKET_ID BC_PACKET_ID DOCUMENT_TYPE DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID BURDEN_COST_FLAG

Columns

Name	Datatype	Length	Mandatory
PACKET_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
TASK_ID	NUMBER	(15)	Yes
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
EXPENDITURE_ITEM_DATE	DATE		Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes
JE_SOURCE_NAME	VARCHAR2	(30)	Yes
STATUS_CODE	VARCHAR2	(1)	Yes
DOCUMENT_TYPE	VARCHAR2	(10)
FUNDS_PROCESS_MODE	VARCHAR2	(1)	Yes
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)	Yes
BUDGET_VERSION_ID	NUMBER	(15)	Yes
BURDEN_COST_FLAG	VARCHAR2	(1)	Yes
BC_PACKET_ID	NUMBER	(15)	Yes
BALANCE_POSTED_FLAG	VARCHAR2	(1)	Yes
ACTUAL_FLAG	VARCHAR2	(1)	Yes
GL_DATE	DATE
PA_DATE	DATE
PERIOD_NAME	VARCHAR2	(15)
PERIOD_YEAR	NUMBER
PERIOD_NUM	NUMBER
BC_COMMITMENT_ID	NUMBER	(15)
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
PROJ_ENCUMBRANCE_TYPE_ID	NUMBER	(15)
TOP_TASK_ID	NUMBER	(15)
PARENT_RESOURCE_ID	NUMBER	(15)
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
EFFECT_ON_FUNDS_CODE	VARCHAR2	(1)
RESULT_CODE	VARCHAR2	(5)
TASK_BUDGET_POSTED	NUMBER
TASK_ENC_POSTED	NUMBER
TASK_ENC_APPROVED	NUMBER
TASK_ACTUAL_POSTED	NUMBER
TASK_ACTUAL_APPROVED	NUMBER
TASK_RESULT_CODE	VARCHAR2	(5)
RES_GRP_BUDGET_POSTED	NUMBER
RES_GRP_ENC_POSTED	NUMBER
RES_GRP_ENC_APPROVED	NUMBER
RES_GRP_ACTUAL_POSTED	NUMBER
RES_GRP_ACTUAL_APPROVED	NUMBER
RES_GRP_RESULT_CODE	VARCHAR2	(5)
RES_BUDGET_POSTED	NUMBER
RES_ENC_POSTED	NUMBER
RES_ENC_APPROVED	NUMBER
RES_ACTUAL_POSTED	NUMBER
RES_ACTUAL_APPROVED	NUMBER
RES_RESULT_CODE	VARCHAR2	(5)
RES_BUDGET_BAL	NUMBER
RES_GRP_BUDGET_BAL	NUMBER
TASK_BUDGET_BAL	NUMBER
TOP_TASK_BUDGET_BAL	NUMBER
PROJECT_BUDGET_BAL	NUMBER
GL_ROW_NUMBER	VARCHAR2	(30)
PARENT_BC_PACKET_ID	NUMBER	(15)
BUD_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
BUD_TASK_ID	NUMBER	(15)
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)
P_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)
TOP_TASK_BUDGET_POSTED	NUMBER
TOP_TASK_ENC_POSTED	NUMBER
TOP_TASK_ENC_APPROVED	NUMBER
TOP_TASK_ACTUAL_POSTED	NUMBER
TOP_TASK_ACTUAL_APPROVED	NUMBER
TOP_TASK_RESULT_CODE	VARCHAR2	(5)
PROJECT_BUDGET_POSTED	NUMBER
PROJECT_ENC_POSTED	NUMBER
PROJECT_ENC_APPROVED	NUMBER
PROJECT_ACTUAL_POSTED	NUMBER
PROJECT_ACTUAL_APPROVED	NUMBER
PROJECT_RESULT_CODE	VARCHAR2	(5)
PROJECT_ACCT_RESULT_CODE	VARCHAR2	(5)
REQUEST_ID	NUMBER	(15)
BUDGET_CCID	NUMBER	(15)
OLD_BUDGET_CCID	NUMBER	(15)
TXN_CCID	NUMBER	(15)
ORG_ID	NUMBER	(15)
ENCUMBRANCE_AMOUNT	NUMBER
PROGRAM_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
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)
DOCUMENT_LINE_ID	NUMBER	(15)
COMPILED_MULTIPLIER	NUMBER
FC_START_DATE	DATE
FC_END_DATE	DATE
EXT_BDGT_FLAG	VARCHAR2	(1)
COMM_TOT_RAW_AMT	NUMBER
COMM_TOT_BD_AMT	NUMBER
COMM_RAW_AMT_RELIEVED	NUMBER
COMM_BD_AMT_RELIEVED	NUMBER
SUMMARY_RECORD_FLAG	VARCHAR2	(1)
EXP_ITEM_ID	NUMBER	(15)
REFERENCE1	VARCHAR2	(100)
REFERENCE2	VARCHAR2	(100)
REFERENCE3	VARCHAR2	(100)
FUNDS_PROCESSING_SEQ	NUMBER	(15)
TXN_INTERFACE_ID	NUMBER	(15)
BC_EVENT_ID	NUMBER	(15)
SESSION_ID	NUMBER	(38)
SERIAL_ID	NUMBER	(38)
BUDGET_LINE_ID	NUMBER	(15)
VENDOR_ID	NUMBER	(15)
BURDEN_METHOD_CODE	VARCHAR2	(30)
MAIN_OR_BACKING_CODE	VARCHAR2	(30)
SOURCE_EVENT_ID	NUMBER	(15)
DOCUMENT_HEADER_ID_2	NUMBER	(15)
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)

Query Text

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


SELECT PACKET_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      SET_OF_BOOKS_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      STATUS_CODE
,      DOCUMENT_TYPE
,      FUNDS_PROCESS_MODE
,      EXPENDITURE_ORGANIZATION_ID
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      BUDGET_VERSION_ID
,      BURDEN_COST_FLAG
,      BC_PACKET_ID
,      BALANCE_POSTED_FLAG
,      ACTUAL_FLAG
,      GL_DATE
,      PA_DATE
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      BC_COMMITMENT_ID
,      ENCUMBRANCE_TYPE_ID
,      PROJ_ENCUMBRANCE_TYPE_ID
,      TOP_TASK_ID
,      PARENT_RESOURCE_ID
,      RESOURCE_LIST_MEMBER_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      TASK_BUDGET_POSTED
,      TASK_ENC_POSTED
,      TASK_ENC_APPROVED
,      TASK_ACTUAL_POSTED
,      TASK_ACTUAL_APPROVED
,      TASK_RESULT_CODE
,      RES_GRP_BUDGET_POSTED
,      RES_GRP_ENC_POSTED
,      RES_GRP_ENC_APPROVED
,      RES_GRP_ACTUAL_POSTED
,      RES_GRP_ACTUAL_APPROVED
,      RES_GRP_RESULT_CODE
,      RES_BUDGET_POSTED
,      RES_ENC_POSTED
,      RES_ENC_APPROVED
,      RES_ACTUAL_POSTED
,      RES_ACTUAL_APPROVED
,      RES_RESULT_CODE
,      RES_BUDGET_BAL
,      RES_GRP_BUDGET_BAL
,      TASK_BUDGET_BAL
,      TOP_TASK_BUDGET_BAL
,      PROJECT_BUDGET_BAL
,      GL_ROW_NUMBER
,      PARENT_BC_PACKET_ID
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      R_FUNDS_CONTROL_LEVEL_CODE
,      RG_FUNDS_CONTROL_LEVEL_CODE
,      T_FUNDS_CONTROL_LEVEL_CODE
,      TT_FUNDS_CONTROL_LEVEL_CODE
,      P_FUNDS_CONTROL_LEVEL_CODE
,      TOP_TASK_BUDGET_POSTED
,      TOP_TASK_ENC_POSTED
,      TOP_TASK_ENC_APPROVED
,      TOP_TASK_ACTUAL_POSTED
,      TOP_TASK_ACTUAL_APPROVED
,      TOP_TASK_RESULT_CODE
,      PROJECT_BUDGET_POSTED
,      PROJECT_ENC_POSTED
,      PROJECT_ENC_APPROVED
,      PROJECT_ACTUAL_POSTED
,      PROJECT_ACTUAL_APPROVED
,      PROJECT_RESULT_CODE
,      PROJECT_ACCT_RESULT_CODE
,      REQUEST_ID
,      BUDGET_CCID
,      OLD_BUDGET_CCID
,      TXN_CCID
,      ORG_ID
,      ENCUMBRANCE_AMOUNT
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      DOCUMENT_LINE_ID
,      COMPILED_MULTIPLIER
,      FC_START_DATE
,      FC_END_DATE
,      EXT_BDGT_FLAG
,      COMM_TOT_RAW_AMT
,      COMM_TOT_BD_AMT
,      COMM_RAW_AMT_RELIEVED
,      COMM_BD_AMT_RELIEVED
,      SUMMARY_RECORD_FLAG
,      EXP_ITEM_ID
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      FUNDS_PROCESSING_SEQ
,      TXN_INTERFACE_ID
,      BC_EVENT_ID
,      SESSION_ID
,      SERIAL_ID
,      BUDGET_LINE_ID
,      VENDOR_ID
,      BURDEN_METHOD_CODE
,      MAIN_OR_BACKING_CODE
,      SOURCE_EVENT_ID
,      DOCUMENT_HEADER_ID_2
,      DOCUMENT_DISTRIBUTION_TYPE
FROM PA.PA_BC_PACKETS_HIST;

Dependencies

[top of page]

PA.PA_BC_PACKETS_HIST does not reference any database object

PA.PA_BC_PACKETS_HIST is referenced by following:

PA: PA_BC_PACKETS_HIST#