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.IRCBV_ASSIGNMENT_STATUSES_V

Object Details

Object Name:	IRCBV_ASSIGNMENT_STATUSES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

Assignment status (from IRC_ASSIGNMENT_STATUSES table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STATUS_CHANGE_DATE	DATE		Yes	Status change date.
STATUS_CHANGE_REASON_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type APL_ASSIGN_REASON).
STATUS_CHANGE_REASON	VARCHAR2	(240)		(Lookup code based on lookup type APL_ASSIGN_REASON).
ASSIGNMENT_STATUS_ID	NUMBER	(15)	Yes	Primary Key for IRC_ASSIGNMENT_STATUSES.
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F.
ASSIGNMENT_STATUS_TYPE_ID	NUMBER	(15)	Yes	Foreign key to PER_ASSIGNMENT_STATUS_TYPES.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT STATUS_CHANGE_DATE
,      STATUS_CHANGE_REASON_M
,      STATUS_CHANGE_REASON
,      ASSIGNMENT_STATUS_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.IRCBV_ASSIGNMENT_STATUSES_V;

Dependencies

[top of page]

APPS.IRCBV_ASSIGNMENT_STATUSES_V references the following:

APPS: HR_BIS - show dependent code; IRC_ASSIGNMENT_STATUSES

APPS.IRCBV_ASSIGNMENT_STATUSES_V is not referenced by any database object