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: CE.CE_BA_SIGNATORIES

Object Details

Object Name:	CE_BA_SIGNATORIES
Object Type:	TABLE
Owner:	CE
FND Design Data:	CE.CE_BA_SIGNATORIES
Subobject Name:
Status:	VALID

This table stores information about the people with signature authority for a bank account. The table continues to store information about deleted signatories, but deleted signatories are flagged to prevent their use.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CE_BA_SIGNATORIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SIGNATORY_ID
CE_BA_SIGNATORIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_ACCOUNT_ID PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Unique identifier of the bank account from
SIGNATORY_ID	NUMBER	(15)	Yes	Unique identifier for each row in this table
PERSON_ID	NUMBER	(15)	Yes	Person_id of the person added as a bank account
SINGLE_LIMIT_AMOUNT	NUMBER			Single limit amount
JOINT_LIMIT_AMOUNT	NUMBER			Joint limit amount
SIGNER_GROUP	VARCHAR2	(60)		Person belongs to this group signatories
OTHER_LIMITS	VARCHAR2	(150)		Other limitations
START_DATE	DATE			Start date of the bank account signatory
END_DATE	DATE			End date
STATUS	VARCHAR2	(60)		Indicates approval status for this signatory as APPROVED, PENDING, or REJECTED
APPROVAL_TYPE_FLAG	VARCHAR2	(1)		M or W. M indicates manually approved. W indicates approval using Oracle Workflow.
DELETED_FLAG	VARCHAR2	(1)		Y or N. Y indicates the record is soft-deleted and cannot be used . Default is N.
REQUESTER_ID	NUMBER	(15)		Person_id of the user submitting the workflow request. employee_id derived from the FND_USER table
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT BANK_ACCOUNT_ID
,      SIGNATORY_ID
,      PERSON_ID
,      SINGLE_LIMIT_AMOUNT
,      JOINT_LIMIT_AMOUNT
,      SIGNER_GROUP
,      OTHER_LIMITS
,      START_DATE
,      END_DATE
,      STATUS
,      APPROVAL_TYPE_FLAG
,      DELETED_FLAG
,      REQUESTER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM CE.CE_BA_SIGNATORIES;

Dependencies

[top of page]

CE.CE_BA_SIGNATORIES does not reference any database object

CE.CE_BA_SIGNATORIES is referenced by following:

APPS: CE_BA_SIGNATORIES