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: PA.PA_BC_COMMITMENTS_ALL#

Object Details

Object Name:	PA_BC_COMMITMENTS_ALL#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BC_COMMITMENT_ID	NUMBER	(15)	Yes
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
PERIOD_NAME	VARCHAR2	(15)
PERIOD_NUM	NUMBER	(22)
BUDGET_VERSION_ID	NUMBER	(15)	Yes
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes
JE_SOURCE_NAME	VARCHAR2	(30)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
DOCUMENT_TYPE	VARCHAR2	(10)	Yes
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)	Yes
TOP_TASK_ID	NUMBER	(15)
PARENT_RESOURCE_ID	NUMBER	(15)
PA_DATE	DATE
GL_DATE	DATE
PROGRAM_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
TRANSFERRED_DATE	DATE
TRANSFER_STATUS_CODE	VARCHAR2	(1)
PROJECT_BATCH_NAME	VARCHAR2	(100)
PROJ_TRANSFER_REJ_REASON	VARCHAR2	(250)
PROJ_ENCUMBRANCE_TYPE_ID	NUMBER	(15)
PROCESS_EXP_ITEM_ID	NUMBER	(15)
PROCESS_CCID	NUMBER	(15)
PERIOD_YEAR	NUMBER
ORG_ID	NUMBER	(15)
LIQUIDATE_GL_DATE	DATE
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
COMMITMENT_BATCH_NAME	VARCHAR2	(100)
COMM_TRANSFER_REJ_REASON	VARCHAR2	(250)
BURDEN_COST_FLAG	VARCHAR2	(1)
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
BUDGET_CCID	NUMBER	(15)
TXN_CCID	NUMBER	(15)
BC_PACKET_ID	NUMBER	(15)	Yes
PARENT_BC_PACKET_ID	NUMBER	(15)
FUNDS_PROCESS_MODE	VARCHAR2	(1)
BUD_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
BUD_TASK_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
ACTUAL_FLAG	VARCHAR2	(1)
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)		Document line identifier
COMPILED_MULTIPLIER	NUMBER			Compiled Burden multiplier
FC_START_DATE	DATE			Funds Check Start Date
FC_END_DATE	DATE			Funds Check End Date
COMM_TOT_RAW_AMT	NUMBER			Total raw cost for the commitment
COMM_TOT_BD_AMT	NUMBER			Total burden cost for the commitment
COMM_RAW_AMT_RELIEVED	NUMBER			Sum of the commitment raw cost relieved
COMM_BD_AMT_RELIEVED	NUMBER			Sum of the commitment burden cost relieved
SUMMARY_RECORD_FLAG	VARCHAR2	(1)		Flag to indicate that the record is summarized by purchase order line, project, task, and expenditure type
EXP_ITEM_ID	NUMBER	(15)		Expenditure item identifier
REFERENCE1	VARCHAR2	(100)		Funds check transaction Reference column
REFERENCE2	VARCHAR2	(100)		Funds check transaction Reference column
REFERENCE3	VARCHAR2	(100)		Funds check transaction Reference column
BC_EVENT_ID	NUMBER	(15)
BUDGET_LINE_ID	NUMBER	(15)
VENDOR_ID	NUMBER	(15)
BURDEN_METHOD_CODE	VARCHAR2	(30)
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 BC_COMMITMENT_ID
,      PACKET_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      PERIOD_NAME
,      PERIOD_NUM
,      BUDGET_VERSION_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      SET_OF_BOOKS_ID
,      DOCUMENT_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      TOP_TASK_ID
,      PARENT_RESOURCE_ID
,      PA_DATE
,      GL_DATE
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      TRANSFERRED_DATE
,      TRANSFER_STATUS_CODE
,      PROJECT_BATCH_NAME
,      PROJ_TRANSFER_REJ_REASON
,      PROJ_ENCUMBRANCE_TYPE_ID
,      PROCESS_EXP_ITEM_ID
,      PROCESS_CCID
,      PERIOD_YEAR
,      ORG_ID
,      LIQUIDATE_GL_DATE
,      ENCUMBRANCE_TYPE_ID
,      COMMITMENT_BATCH_NAME
,      COMM_TRANSFER_REJ_REASON
,      BURDEN_COST_FLAG
,      RESOURCE_LIST_MEMBER_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      BUDGET_CCID
,      TXN_CCID
,      BC_PACKET_ID
,      PARENT_BC_PACKET_ID
,      FUNDS_PROCESS_MODE
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      REQUEST_ID
,      ACTUAL_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      DOCUMENT_LINE_ID
,      COMPILED_MULTIPLIER
,      FC_START_DATE
,      FC_END_DATE
,      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
,      BC_EVENT_ID
,      BUDGET_LINE_ID
,      VENDOR_ID
,      BURDEN_METHOD_CODE
,      DOCUMENT_HEADER_ID_2
,      DOCUMENT_DISTRIBUTION_TYPE
FROM PA.PA_BC_COMMITMENTS_ALL#;

Dependencies

[top of page]

PA.PA_BC_COMMITMENTS_ALL# references the following:

PA: PA_BC_COMMITMENTS_ALL

PA.PA_BC_COMMITMENTS_ALL# is referenced by following:

APPS: PA_BC_COMMITMENTS; PA_BC_COMMITMENTS_ALL