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_FIN_PLAN_AMOUNT_SETS

Object Details

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

This table stores the various amount sets available for financial plans. Amount sets are used internally to control what amounts can be planned for in a financial plan. Currently, all data in this table is either predefined or populated by other modules. There is no interface to enter or maintain data in this table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FIN_PLAN_AMOUNT_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FIN_PLAN_AMOUNT_SET_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FIN_PLAN_AMOUNT_SET_ID	NUMBER	(15)	Yes	The system generated number that uniquely identifies the amount set
AMOUNT_SET_TYPE_CODE	VARCHAR2	(30)	Yes	Indicates the amount set type.
RAW_COST_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether raw cost could be entered.
BURDENED_COST_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether burdened cost could be entered.
COST_QTY_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether cost quantity could be entered
REVENUE_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether revenue could be entered.
REVENUE_QTY_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether reenue quantity could be entered.
TP_COST_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether transfer price cost could be entered.
TP_REVENUE_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether transfer price revenue could be entered.
UTIL_PERCENT_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether utilization percent could be entered.
UTIL_HOURS_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether utilization hours could be entered.
CAPACITY_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether capacity could be entered.
PRE_DEFINED_FLAG	VARCHAR2	(1)	Yes	The identifier of pre-defined data.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
ALL_QTY_FLAG	VARCHAR2	(1)		Indicates whether quantity can be entered when planning for Cost and Revenue together
BILL_RATE_FLAG	VARCHAR2	(1)		A flag to indicate whether bill rate could be entered.
COST_RATE_FLAG	VARCHAR2	(1)		A flag to indicate whether cost rate could be entered.
BURDEN_RATE_FLAG	VARCHAR2	(1)		A flag to indicate whether burden rate could be entered.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT FIN_PLAN_AMOUNT_SET_ID
,      AMOUNT_SET_TYPE_CODE
,      RAW_COST_FLAG
,      BURDENED_COST_FLAG
,      COST_QTY_FLAG
,      REVENUE_FLAG
,      REVENUE_QTY_FLAG
,      TP_COST_FLAG
,      TP_REVENUE_FLAG
,      UTIL_PERCENT_FLAG
,      UTIL_HOURS_FLAG
,      CAPACITY_FLAG
,      PRE_DEFINED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ALL_QTY_FLAG
,      BILL_RATE_FLAG
,      COST_RATE_FLAG
,      BURDEN_RATE_FLAG
,      ZD_EDITION_NAME
FROM PA.PA_FIN_PLAN_AMOUNT_SETS;

Dependencies

[top of page]

PA.PA_FIN_PLAN_AMOUNT_SETS does not reference any database object

PA.PA_FIN_PLAN_AMOUNT_SETS is referenced by following:

PA: PA_FIN_PLAN_AMOUNT_SETS#