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: CSD.CSD_GROUP_JOB_PARAM_TEMP

Object Details

Object Name:	CSD_GROUP_JOB_PARAM_TEMP
Object Type:	TABLE
Owner:	CSD
FND Design Data:	CSD.CSD_GROUP_JOB_PARAM_TEMP
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_JOB_ID	NUMBER		Yes	Unique Identifier for the table.
REPAIR_GROUP_ID	NUMBER		Yes	Foreign key to CSD_REPAIR_ORDER_GROUPS table.
INVENTORY_ITEM_ID	NUMBER		Yes	Represents inventory item. Foreign key to MTL_SYSTEM_ITEMS_B.
ORGANIZATION_ID	NUMBER		Yes	Represents inventory organization. Foreign key to MTL_SYSTEM_ITEMS_B.
JOB_TYPE	NUMBER			Type of WIP job created.
ROUTING_REFERENCE_ID	NUMBER			Routing reference for the WIP job.
ALTERNATE_DESIGNATOR_CODE	VARCHAR2	(10)		Alternate route for the job.
JOB_STATUS_TYPE	VARCHAR2	(30)		Status of the job created. Could be either Standard or Non-standard.
ACCOUNTING_CLASS	VARCHAR2	(10)	Yes	The WIP accounting class used for the job.
START_DATE	DATE			Start date for the job.
COMPLETION_DATE	DATE			Completion date for the job.
QUANTITY_RECEIVED	NUMBER			The quantity received for the repair order group.
QUANTITY_SUBMITTED	NUMBER			The quantity submitted to the WIP job for the repair order group.
ITEM_REVISION	VARCHAR2	(240)		Inventory item revision.
CREATED_BY	NUMBER		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		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
INCIDENT_ID	NUMBER			Reference for Service Request. Foreign key to CS_INCIDENTS_ALL.
PROCESS_ID	NUMBER			Identifier used to group mass repair orders into WIP jobs. The orders are grouped by item and repair type.

Query Text

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


SELECT GROUP_JOB_ID
,      REPAIR_GROUP_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      JOB_TYPE
,      ROUTING_REFERENCE_ID
,      ALTERNATE_DESIGNATOR_CODE
,      JOB_STATUS_TYPE
,      ACCOUNTING_CLASS
,      START_DATE
,      COMPLETION_DATE
,      QUANTITY_RECEIVED
,      QUANTITY_SUBMITTED
,      ITEM_REVISION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      INCIDENT_ID
,      PROCESS_ID
FROM CSD.CSD_GROUP_JOB_PARAM_TEMP;

Dependencies

[top of page]

CSD.CSD_GROUP_JOB_PARAM_TEMP does not reference any database object

CSD.CSD_GROUP_JOB_PARAM_TEMP is referenced by following:

CSD: CSD_GROUP_JOB_PARAM_TEMP#