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

Object Details

Object Name:	JTF_IH_ACTION_ACTION_ITEMS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_IH_ACTION_ACTION_ITEMS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_ITEM_ID	NUMBER	(15)	Yes	Action Item ID. Foreign key for JTF_IH_ACTION_ITEMS_TL table
ACTION_ID	NUMBER	(15)	Yes	Action ID. Foreign key for JTF_IH_ACTIONS_TL table
OUTCOME_ID	NUMBER	(15)		Outcome ID. Foreign key for JTF_IH_OUTCOMES_TL table
RESULT_ID	NUMBER	(15)		Result ID. Foreign key for JTF_IH_RESULTS_TL table
REASON_ID	NUMBER	(15)		Reason ID. Foreign key for JTF_IH_REASONS_TL table
DEFAULT_WRAP_ID	NUMBER			Defailt Wrap ID. Foreign key for JTF_IH_WRAP_UPS_VL view
ACTION_ITEM_DESC	VARCHAR2	(240)	Yes	Short Description for Action Items
ACTION_DESC	VARCHAR2	(240)		Short Description for current Action
OUTCOME_DESC	VARCHAR2	(240)		Short Description current Outcome_ID
RESULT_DESC	VARCHAR2	(240)		Short Description current Result_ID
REASON_DESC	VARCHAR2	(240)		Short Description current Reason_ID
ACTION_ACTIVE	VARCHAR2	(1)
ACTION_ITEM_ACTIVE	VARCHAR2	(1)
OBJECT_VERSION_NUMBER	NUMBER	(9)		Sequential number used for database locking control when usinging HTML as a user interface.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DEF_WRAP_START_DATE	DATE
DEF_WRAP_END_DATE	DATE

Query Text

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


SELECT ACTION_ITEM_ID
,      ACTION_ID
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      DEFAULT_WRAP_ID
,      ACTION_ITEM_DESC
,      ACTION_DESC
,      OUTCOME_DESC
,      RESULT_DESC
,      REASON_DESC
,      ACTION_ACTIVE
,      ACTION_ITEM_ACTIVE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEF_WRAP_START_DATE
,      DEF_WRAP_END_DATE
FROM APPS.JTF_IH_ACTION_ACTION_ITEMS_VL;

Dependencies

[top of page]

APPS.JTF_IH_ACTION_ACTION_ITEMS_VL references the following:

APPS: JTF_IH_ACTIONS_VL; JTF_IH_ACTION_ACTION_ITEMS; JTF_IH_ACTION_ITEMS_VL; JTF_IH_WRAP_UPS_VL

APPS.JTF_IH_ACTION_ACTION_ITEMS_VL is not referenced by any database object