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_RES_FORMATS_B

Object Details

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

This table stores information pertaining to pre-defined resource formats in Oracle Projects

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RES_FORMATS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RES_FORMAT_ID ZD_EDITION_NAME
PA_RES_FORMATS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RES_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RES_FORMAT_ID	NUMBER	(15)	Yes	Unique identifier of resource format.
RESOURCE_FORMAT_SEQ	NUMBER		Yes	The display number for the format, used in ordering.
RESOURCE_CLASS_ID	NUMBER	(15)	Yes	Resource class of the resource format.
RES_TYPE_ID	NUMBER	(15)		Resource type (if any) of the resource format.
RES_TYPE_ENABLED_FLAG	VARCHAR2	(1)		Indicates whether Resource Type is used in the resource format.
RESOURCE_TYPE_DISP_CHARS	NUMBER			Default number of characters used for resource type in resource alias.
ORGN_ENABLED_FLAG	VARCHAR2	(1)		Indicates whether Organization is used in the resource format.
ORGN_DISP_CHARS	NUMBER			Default number of characters used for organization in resource alias.
FIN_CAT_ENABLED_FLAG	VARCHAR2	(1)		Indicates whether Financial Category is used in the resource format.
FIN_CAT_DISP_CHARS	NUMBER			Default number of characters used for financial category in resource alias.
INCURRED_BY_ENABLED_FLAG	VARCHAR2	(1)		Indicates whether Incurred By Resource is used in the resource format.
INCURRED_BY_DISP_CHARS	NUMBER			Default number of characters used for incurred by in resource alias.
SUPPLIER_ENABLED_FLAG	VARCHAR2	(1)		Indicates whether Supplier is used in the resource format.
SUPPLIER_DISP_CHARS	NUMBER			Default number of characters used for supplier in resource alias.
ROLE_ENABLED_FLAG	VARCHAR2	(1)		Indicates whether Role is used in the resource format.
ROLE_DISP_CHARS	NUMBER			Default number of characters used for role in resource alias.
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		Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column.
RESOURCE_CLASS_FLAG	VARCHAR2	(1)		Indicates the resource is a resource class.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT RES_FORMAT_ID
,      RESOURCE_FORMAT_SEQ
,      RESOURCE_CLASS_ID
,      RES_TYPE_ID
,      RES_TYPE_ENABLED_FLAG
,      RESOURCE_TYPE_DISP_CHARS
,      ORGN_ENABLED_FLAG
,      ORGN_DISP_CHARS
,      FIN_CAT_ENABLED_FLAG
,      FIN_CAT_DISP_CHARS
,      INCURRED_BY_ENABLED_FLAG
,      INCURRED_BY_DISP_CHARS
,      SUPPLIER_ENABLED_FLAG
,      SUPPLIER_DISP_CHARS
,      ROLE_ENABLED_FLAG
,      ROLE_DISP_CHARS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RESOURCE_CLASS_FLAG
,      ZD_EDITION_NAME
FROM PA.PA_RES_FORMATS_B;

Dependencies

[top of page]

PA.PA_RES_FORMATS_B does not reference any database object

PA.PA_RES_FORMATS_B is referenced by following:

PA: PA_RES_FORMATS_B#