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]

VIEW: APPS.CE_P_BA_SIGNATORY_HIST_V

Object Details

Object Name:	CE_P_BA_SIGNATORY_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_P_BA_SIGNATORY_HIST_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This public view consolidates bank account signatory information from tables ce_ba_signatories and ce_ba_signatory_hist_h. This view provides complete history information in terms of creation, updation, approval, rejection and deletion of the signatory.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database row identifier
SIGNATORY_ID	NUMBER	(15)	Yes	Signatory identifier
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank Account identifier
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)		Bank Account number
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank Account name
BANK_NAME	VARCHAR2	(360)	Yes	Bank Name
BANK_BRANCH_NAME	VARCHAR2	(360)	Yes	Branch Name
CURRENCY	VARCHAR2	(15)		Currency
PERSON_ID	NUMBER	(15)	Yes	Person identifier
PERSON_NAME	VARCHAR2	(240)		Person name
PERSON_TYPE	VARCHAR2	(4000)		Person type
PERSON_ORG_NAME	VARCHAR2	(4000)		Person organization
PERSON_JOB	VARCHAR2	(4000)		Person job
PERSON_LOCATION	VARCHAR2	(45)		Person location
PERSON_EMAIL	VARCHAR2	(240)		Person email
SINGLE_LIMIT_AMOUNT	NUMBER			Single limit amount
JOINT_LIMIT_AMOUNT	NUMBER			Joint limit amount
SIGNER_GROUP	VARCHAR2	(60)		Person belongs to this group of signatories
OTHER_LIMITS	VARCHAR2	(150)		Other limitations
START_DATE	DATE			Start date of the bank account signatory
END_DATE	DATE			End date of the bank account signatory
STATUS	VARCHAR2	(60)		Indicates approval status for this signatory
APPROVAL_TYPE_FLAG	VARCHAR2	(1)		Flag to indicate the approval type
DELETED_FLAG	VARCHAR2	(1)		Flag to indicate whether this record has been deleted
REQUESTER_ID	NUMBER	(15)		Person identifier of the user submitting the workflow request
ACTION	VARCHAR2	(40)		Approvers notification responses
ACTION_BY	NUMBER	(15)	Yes	Approver
ACTION_DATE	DATE		Yes	The date of approval
CURRENT_RECORD_FLAG	VARCHAR2	(1)		Flag to indicate whether this is the latest history record
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column

Query Text

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


SELECT ROW_ID
,      SIGNATORY_ID
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NUMBER
,      BANK_ACCOUNT_NAME
,      BANK_NAME
,      BANK_BRANCH_NAME
,      CURRENCY
,      PERSON_ID
,      PERSON_NAME
,      PERSON_TYPE
,      PERSON_ORG_NAME
,      PERSON_JOB
,      PERSON_LOCATION
,      PERSON_EMAIL
,      SINGLE_LIMIT_AMOUNT
,      JOINT_LIMIT_AMOUNT
,      SIGNER_GROUP
,      OTHER_LIMITS
,      START_DATE
,      END_DATE
,      STATUS
,      APPROVAL_TYPE_FLAG
,      DELETED_FLAG
,      REQUESTER_ID
,      ACTION
,      ACTION_BY
,      ACTION_DATE
,      CURRENT_RECORD_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.CE_P_BA_SIGNATORY_HIST_V;

Dependencies

[top of page]

APPS.CE_P_BA_SIGNATORY_HIST_V references the following:

APPS: CE_BANK_ACCOUNTS_V; CE_BANK_BRANCHES_V; CE_BA_SIGNATORIES; CE_BA_SIGNATORY_HIST_H; FND_ACCESS_CONTROL_UTIL - show dependent code; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_PERSON_TYPE_USAGE_INFO - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; PER_ALL_ASSIGNMENTS_F; PER_PEOPLE_F; XTR_USER_ACCESS - show dependent code

APPS.CE_P_BA_SIGNATORY_HIST_V is not referenced by any database object