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

PA_BC_COMMITMENTS holds all the commitment transactions (Req, PO and Payables) that are funds checked. When maintain project balances programs sweeps the commitment records to project balances, the commitments are inserted into this table.

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	Unique identifier for a commitment.
PACKET_ID	NUMBER	(15)	Yes	Budgetary control packet identifier
PROJECT_ID	NUMBER	(15)	Yes	Project identifier
TASK_ID	NUMBER	(15)	Yes	Task identifier
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type for which this transaction was created
EXPENDITURE_ITEM_DATE	DATE		Yes	Date when the transaction was charged
PERIOD_NAME	VARCHAR2	(15)		The GL period name for which the transaction was created.
PERIOD_NUM	NUMBER	(22)		The GL period num for which the transaction was created.
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget version against which this transaction maps
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes	The journal entry category name
JE_SOURCE_NAME	VARCHAR2	(30)	Yes	The journal entry source name
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The accounting books identifier.
DOCUMENT_TYPE	VARCHAR2	(10)	Yes	Indicates the amount type for any of these categories
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes	Expenditure organization identifier
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes	Document header identifier
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)	Yes	Document distribution identifier
TOP_TASK_ID	NUMBER	(15)		Top task identifier
PARENT_RESOURCE_ID	NUMBER	(15)		Resource group identifier
PA_DATE	DATE			The PA date in which the commitment was funds checked.
GL_DATE	DATE			The GL date in which the commitment was funds checked.
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			The date when the commitment was transferred to other Oracle Applications
TRANSFER_STATUS_CODE	VARCHAR2	(1)		This is the status of the commitment line when the liquidation entries are transferred to General Ledger. This column is used only for those commitment lines where Burden_Cost_Flag is "O".
PROJECT_BATCH_NAME	VARCHAR2	(100)		Refers to batches of lines transferred together to GL for project budget encumbrance liquidation entries for commitment transactions.
PROJ_TRANSFER_REJ_REASON	VARCHAR2	(250)		Indicates why the project budget encumbrance liquidation entries were rejected by the PA cost transfer program.
PROJ_ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Project encumbrance type identifier used during processing.
PROCESS_EXP_ITEM_ID	NUMBER	(15)		Temporary expenditure item identifier used during processing.
PROCESS_CCID	NUMBER	(15)		Temporary code combination identifier used during processing.
PERIOD_YEAR	NUMBER			The year in the GL period when the transaction was created.
ORG_ID	NUMBER	(15)		Operating unit of the commitment.
LIQUIDATE_GL_DATE	DATE			Temporary GL date used during processing.
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Commitment encumbrance type identifier used during processing.
COMMITMENT_BATCH_NAME	VARCHAR2	(100)		Refers to batches of lines transferred together to GL for encumbrance liquidation entries for commitment transactions.
COMM_TRANSFER_REJ_REASON	VARCHAR2	(250)		Reason why the commitment encumbrance liquidation entries were rejected by the PA cost transfer program.
BURDEN_COST_FLAG	VARCHAR2	(1)		Temporary flag used during processing to identify burden lines. Valid values are "O", "R" and "N"
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes	Resource list member identifier
ENTERED_DR	NUMBER			Transaction debit amount in entered currency
ENTERED_CR	NUMBER			Transaction credit amount in entered currency
ACCOUNTED_DR	NUMBER			Transaction debit amount in accounting currency
ACCOUNTED_CR	NUMBER			Transaction credit amount in accounting currency
BUDGET_CCID	NUMBER	(15)		The account of the budget line to which the commitment was mapped.
TXN_CCID	NUMBER	(15)		The account in which the actual / commitment transaction was posted.
BC_PACKET_ID	NUMBER	(15)	Yes	Budgetary control record identifier
PARENT_BC_PACKET_ID	NUMBER	(15)		This column is populated if the transaction is a burden cost. It is populated with the bc packet id of the source.
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)		Budgeted resource list member identifier
BUD_TASK_ID	NUMBER	(15)		Budgeted task identifier
REQUEST_ID	NUMBER	(15)		Request id for a concurrent program
ACTUAL_FLAG	VARCHAR2	(1)		Indicates the balance type.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
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:

PA: PA_BC_COMMITMENTS_ALL#