[Home] [Help] [Dependency Information]
Object Name: | BOM_RTG_OPER_RES_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_RTG_OPER_RES_TEMP |
Subobject Name: | |
Status: | VALID |
BOM.BOM_RTG_OPER_RES_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSEMBLYITEMNAME | VARCHAR2 | (81) | ||
ORGANIZATIONCODE | VARCHAR2 | (3) | ||
ALTERNATEROUTINGCODE | VARCHAR2 | (10) | ||
OPERATIONSEQUENCENUMBER | NUMBER | |||
OPERATIONTYPE | NUMBER | |||
STARTEFFECTIVEDATE | VARCHAR2 | (19) | ||
RESOURCESEQUENCENUMBER | NUMBER | |||
RESOURCECODE | VARCHAR2 | (10) | ||
ACTIVITY | VARCHAR2 | (10) | ||
STANDARDRATEFLAG | NUMBER | |||
ASSIGNEDUNITS | VARCHAR2 | (150) | ||
USAGERATEORAMOUNT | VARCHAR2 | (150) | ||
USAGERATEORAMOUNTINVERSE | VARCHAR2 | (150) | ||
BASISTYPE | NUMBER | |||
SCHEDULEFLAG | NUMBER | |||
RESOURCEOFFSETPERCENT | VARCHAR2 | (150) | ||
AUTOCHARGETYPE | NUMBER | |||
SCHEDULESEQUENCENUMBER | NUMBER | |||
PRINCIPLEFLAG | NUMBER | |||
ATTRIBUTECATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ORIGINALSYSTEMREFERENCE | VARCHAR2 | (50) | ||
SETUPTYPE | VARCHAR2 | (30) | ||
SUBSTITUTEGROUPNUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ASSEMBLYITEMNAME
, ORGANIZATIONCODE
, ALTERNATEROUTINGCODE
, OPERATIONSEQUENCENUMBER
, OPERATIONTYPE
, STARTEFFECTIVEDATE
, RESOURCESEQUENCENUMBER
, RESOURCECODE
, ACTIVITY
, STANDARDRATEFLAG
, ASSIGNEDUNITS
, USAGERATEORAMOUNT
, USAGERATEORAMOUNTINVERSE
, BASISTYPE
, SCHEDULEFLAG
, RESOURCEOFFSETPERCENT
, AUTOCHARGETYPE
, SCHEDULESEQUENCENUMBER
, PRINCIPLEFLAG
, ATTRIBUTECATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORIGINALSYSTEMREFERENCE
, SETUPTYPE
, SUBSTITUTEGROUPNUMBER
FROM BOM.BOM_RTG_OPER_RES_TEMP;
BOM.BOM_RTG_OPER_RES_TEMP does not reference any database object
BOM.BOM_RTG_OPER_RES_TEMP is referenced by following:
|
|
|