[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_INVENTORY_COMPONENTS_TEMP

Object Details

Object Name:	BOM_INVENTORY_COMPONENTS_TEMP
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_INVENTORY_COMPONENTS_TEMP
Subobject Name:
Status:	VALID

Temporary Table Details

BOM.BOM_INVENTORY_COMPONENTS_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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT ORGANIZATIONCODE
,      ASSEMBLYITEMNAME
,      STARTEFFECTIVEDATE
,      DISABLEDATE
,      OPERATIONSEQUENCENUMBER
,      COMPONENTITEMNAME
,      ALTERNATEBOMCODE
,      NEWEFFECTIVITYDATE
,      NEWOPERATIONSEQUENCENUMBER
,      ITEMSEQUENCENUMBER
,      QUANTITYPERASSEMBLY
,      PLANNINGPERCENT
,      PROJECTEDYIELD
,      INCLUDEINCOSTROLLUP
,      WIPSUPPLYTYPE
,      SOBASIS
,      OPTIONAL
,      MUTUALLYEXCLUSIVE
,      CHECKATP
,      SHIPPINGALLOWED
,      REQUIREDTOSHIP
,      REQUIREDFORREVENUE
,      INCLUDEONSHIPDOCS
,      QUANTITYRELATED
,      SUPPLYSUBINVENTORY
,      LOCATIONNAME
,      MINIMUMALLOWEDQUANTITY
,      MAXIMUMALLOWEDQUANTITY
,      COMMENTS
,      ATTRIBUTECATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FROMENDITEMUNITNUMBER
,      NEWFROMENDITEMUNITNUMBER
,      TOENDITEMUNITNUMBER
,      ORIGINALSYSTEMREFERENCE
,      DELETEGROUPNAME
,      DGDESCRIPTION
,      ENFORCEINTREQUIREMENTS
,      SUGGESTEDVENDORNAME
,      UNITPRICE
,      BASISTYPE
FROM BOM.BOM_INVENTORY_COMPONENTS_TEMP;

Dependencies

[top of page]

BOM.BOM_INVENTORY_COMPONENTS_TEMP does not reference any database object

BOM.BOM_INVENTORY_COMPONENTS_TEMP is referenced by following:

APPS

BOM_INVENTORY_COMPONENTS_TEMP