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_COMMITMENTS_ALL

Object Details

Object Name:	PA_BC_COMMITMENTS_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BC_COMMITMENTS_ALL
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BC_COMMITMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BC_COMMITMENT_ID
PA_BC_COMMITMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID EXPENDITURE_ITEM_DATE
PA_BC_COMMITMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE
PA_BC_COMMITMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE
PA_BC_COMMITMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
PA_BC_COMMITMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID
PA_BC_COMMITMENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE REQUEST_ID
PA_BC_COMMITMENTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXP_ITEM_ID
PA_BC_COMMITMENTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BC_EVENT_ID

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)		This column is updated by the program id when a concurrent program is run
PROGRAM_APPLICATION_ID	NUMBER	(15)		This column is updated by the program application id when a concurrent program is run
PROGRAM_UPDATE_DATE	DATE			This column is updated by sysdate when a concurrent program is run
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)		Value of this column indicates what processing the record is created for: T => Transaction Processing B => Budget Baselining
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)		Identifier of the budgetary control event
BUDGET_LINE_ID	NUMBER	(15)		Identifier of the budget line of the transaction
VENDOR_ID	NUMBER	(15)		Identifier of the supplier
BURDEN_METHOD_CODE	VARCHAR2	(30)		Indicates the burden method of the project
DOCUMENT_HEADER_ID_2	NUMBER	(15)		Second document header identifieR
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)		Document distribution type

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 does not reference any database object

PA.PA_BC_COMMITMENTS_ALL is referenced by following:

APPS: PA_BC_COMMITMENTS; PA_BC_COMMITMENTS_ALL