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: AMW.AMW_FIN_ITEM_ACC_CTRL

Object Details

Object Name:	AMW_FIN_ITEM_ACC_CTRL
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_FIN_ITEM_ACC_CTRL
Subobject Name:
Status:	VALID

Holds financial item and account information related to Risk

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_FIN_ITEM_ACC_CTRL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE
AMW_FIN_ITEM_ACC_CTRL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FIN_CERTIFICATION_ID
AMW_FIN_ITEM_ACC_CTRL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
AMW_FIN_ITEM_ACC_CTRL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPINION_LOG_ID
AMW_FIN_ITEM_ACC_CTRL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTROL_ID
AMW_FIN_ITEM_ACC_CTRL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTROL_REV_ID
AMW_FIN_ITEM_ACC_CTRL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_GROUP_ID NATURAL_ACCOUNT_ID
AMW_FIN_ITEM_ACC_CTRL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FINANCIAL_STATEMENT_ID FINANCIAL_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_TYPE	VARCHAR2	(30)	Yes	OBJECT TYPE. ITEM OR ACCOUNT OR STATEMENT
FIN_CERTIFICATION_ID	NUMBER		Yes	Financial Certification I
STATEMENT_GROUP_ID	NUMBER			STATEMENT_GROUP_ID for the Certification Record for this Process
FINANCIAL_STATEMENT_ID	NUMBER			FINANCIAL_STATEMENT_ID for this Procecss
FINANCIAL_ITEM_ID	NUMBER			FINANCIAL_ITEM_ID FOR Financial Certification
ACCOUNT_GROUP_ID	NUMBER			ACCOUNT_GROUP_ID
NATURAL_ACCOUNT_ID	NUMBER			NATURAL_ACCOUNT_ID
ORGANIZATION_ID	NUMBER			ORGANIZATION_ID
CONTROL_ID	NUMBER			CONTROL_ID
CONTROL_REV_ID	NUMBER			CONTROL_REV_ID
OPINION_LOG_ID	NUMBER			OPINION_LOG_ID
CREATED_BY	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER			This column is used for optimistic locking
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT OBJECT_TYPE
,      FIN_CERTIFICATION_ID
,      STATEMENT_GROUP_ID
,      FINANCIAL_STATEMENT_ID
,      FINANCIAL_ITEM_ID
,      ACCOUNT_GROUP_ID
,      NATURAL_ACCOUNT_ID
,      ORGANIZATION_ID
,      CONTROL_ID
,      CONTROL_REV_ID
,      OPINION_LOG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM AMW.AMW_FIN_ITEM_ACC_CTRL;

Dependencies

[top of page]

AMW.AMW_FIN_ITEM_ACC_CTRL does not reference any database object

AMW.AMW_FIN_ITEM_ACC_CTRL is referenced by following:

APPS: AMW_FIN_COSO_VIEWS_PVT - show dependent code; AMW_FIN_ITEM_ACC_CTRL