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: ISC.ISC_FS_TASK_ACT_BAC_STG

Object Details

Object Name:	ISC_FS_TASK_ACT_BAC_STG
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

This table is used to manage the incremental load of ISC_FS_TASK_ACTIVITY_F and ISC_FS_TASK_BACKLOG_F.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER		Yes	Task identifier
ACT_BAC_ASSIGNEE_ID	NUMBER			Assignee Resource identifier for Activity/Backlog reporting
ACT_BAC_DISTRICT_ID	NUMBER			Assignee District identifier for Activity/Backlog reporting
INVENTORY_ITEM_ID	NUMBER			Inventory Item identifier
INV_ORGANIZATION_ID	NUMBER			Inventory Organization identifier
CUSTOMER_ID	NUMBER			Customer Identifier
PLANNED_START_DATE	DATE			Planned Start Date (and time)
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(60)		Source Object Type identifier - typically "SR"
TASK_TYPE_ID	NUMBER			Task Type identifier
TASK_TYPE_RULE	VARCHAR2	(30)		Rule associated with Task Type - typically "DISPATCH"
DELETED_FLAG	VARCHAR2	(1)		Indicates if Task has been logically deleted
TASK_AUDIT_ID	NUMBER		Yes	Task audit identifier
BACKLOG_ROWID	ROWID	(10)		ROWID (ISC_FS_TASK_BACKLOG_F) of previous Task Backlog row.
BACKLOG_STATUS_CODE	NUMBER			Backlog Status Code: 1 - IN PLANNING, 2 - ASSIGNED, 3 - WORKING, 4 - COMPLETED, 5 - OTHER
STATUS_FLAG	VARCHAR2	(1)		Indicates if Task Status is open "O" or closed "C"
AUDIT_DATE	DATE			Audit Date (and time)
FIRST_OPENED	NUMBER			"1" if first opened activity occured
REOPENED	NUMBER			"1" if reopened activity occured
CLOSED	NUMBER			"1" if closed activity occured
LAST_ROW_FOR_DAY_FLAG	VARCHAR2	(1)		Indicates if this is the last audit row for the day for the task
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_LOGIN_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column
ACT_BAC_ASSIGNEE_TYPE	VARCHAR2	(8)		Assignee Resource type: RESOURCE or GROUP or TEAM

Query Text

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


SELECT TASK_ID
,      ACT_BAC_ASSIGNEE_ID
,      ACT_BAC_DISTRICT_ID
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      CUSTOMER_ID
,      PLANNED_START_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      TASK_TYPE_ID
,      TASK_TYPE_RULE
,      DELETED_FLAG
,      TASK_AUDIT_ID
,      BACKLOG_ROWID
,      BACKLOG_STATUS_CODE
,      STATUS_FLAG
,      AUDIT_DATE
,      FIRST_OPENED
,      REOPENED
,      CLOSED
,      LAST_ROW_FOR_DAY_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ACT_BAC_ASSIGNEE_TYPE
FROM ISC.ISC_FS_TASK_ACT_BAC_STG;

Dependencies

[top of page]

ISC.ISC_FS_TASK_ACT_BAC_STG does not reference any database object

ISC.ISC_FS_TASK_ACT_BAC_STG is referenced by following:

APPS: ISC_FS_TASK_ACT_BAC_STG