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_TRANSACTION_CONTROLS

Object Details

Object Name:	PA_TRANSACTION_CONTROLS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_TRANSACTION_CONTROLS
Subobject Name:
Status:	VALID

PA_TRANSACTION_CONTROLS stores the transaction
controls defined for projects or tasks. Transaction
controls are used to control what expenditure items
can be charged to a particular project or task, and
whether the items are non-billable. You can configure
transaction controls by employee, expenditure
category, expenditure type, and non-labor resource.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	3
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TRANSACTION_CONTROLS_U1	NORMAL	UNIQUE	APPS_TS_SEED	PROJECT_ID EXPENDITURE_CATEGORY TASK_ID PERSON_ID EXPENDITURE_TYPE NON_LABOR_RESOURCE START_DATE_ACTIVE
PA_TRANSACTION_CONTROLS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	PROJECT_ID PERSON_ID TASK_ID EXPENDITURE_CATEGORY
PA_TRANSACTION_CONTROLS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	PERSON_ID PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the transaction control applies
START_DATE_ACTIVE	DATE		Yes	First effective date of the transaction control
CHARGEABLE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the expenditure items that apply to the transaction control classification can be charged
BILLABLE_INDICATOR	VARCHAR2	(1)	Yes	Flag that indicates if the expenditure items that apply to the transaction control are non-billable, or if their billability is determined from the task
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
TASK_ID	NUMBER	(15)		The identifier of the task for which the transaction control applies
PERSON_ID	NUMBER	(9)		The identifier of the person for which the transaction control applies
EXPENDITURE_CATEGORY	VARCHAR2	(30)		The expenditure category for which the transaction control applies
EXPENDITURE_TYPE	VARCHAR2	(30)		The expenditure type for which the transaction control applies
NON_LABOR_RESOURCE	VARCHAR2	(20)		The non labor resource for which the transaction control applies
END_DATE_ACTIVE	DATE			The last effective date of the transaction control
SCHEDULED_EXP_ONLY	VARCHAR2	(1)		Flag indicating to allow scheduled expenditures
EMPLOYEES_ONLY_FLAG	VARCHAR2	(1)		Flag to limit transactions to employees only.
WORKPLAN_RES_ONLY_FLAG	VARCHAR2	(1)		Flag to limit transactions to workplan resources only

Query Text

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


SELECT PROJECT_ID
,      START_DATE_ACTIVE
,      CHARGEABLE_FLAG
,      BILLABLE_INDICATOR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TASK_ID
,      PERSON_ID
,      EXPENDITURE_CATEGORY
,      EXPENDITURE_TYPE
,      NON_LABOR_RESOURCE
,      END_DATE_ACTIVE
,      SCHEDULED_EXP_ONLY
,      EMPLOYEES_ONLY_FLAG
,      WORKPLAN_RES_ONLY_FLAG
FROM PA.PA_TRANSACTION_CONTROLS;

Dependencies

[top of page]

PA.PA_TRANSACTION_CONTROLS does not reference any database object

PA.PA_TRANSACTION_CONTROLS is referenced by following:

APPS: PA_TRANSACTION_CONTROLS