DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_PLM_EXPLOSION_TEMP

Object Details
Object Name: BOM_PLM_EXPLOSION_TEMP
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_PLM_EXPLOSION_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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TOP_BILL_SEQUENCE_ID NUMBER
Yes Bill identifier of level 0 items
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
COMMON_BILL_SEQUENCE_ID NUMBER

Common bill of material unique identifier
COMMON_ORGANIZATION_ID NUMBER

ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPONENT_SEQUENCE_ID NUMBER

Component unique identifier
COMPONENT_ITEM_ID NUMBER

Component item identifier
COMPONENT_QUANTITY NUMBER

Quantity of component in bill of material
PLAN_LEVEL NUMBER
Yes Level in bill
EXTENDED_QUANTITY NUMBER

Extended quantity including quantity per, yield, and shrinkage
SORT_ORDER VARCHAR2 (2000) Yes Sorting sequence for the explosion
GROUP_ID NUMBER

Explosion identifier
TOP_ALTERNATE_DESIGNATOR VARCHAR2 (10)
Alternate designator for level 0
COMPONENT_YIELD_FACTOR NUMBER

Component yield
TOP_ITEM_ID NUMBER

Item identifier of level 0 item
COMPONENT_CODE VARCHAR2 (1000)
Concatenation of component item identifiers
INCLUDE_IN_ROLLUP_FLAG NUMBER

Flag indicating if component is to be used when rolling up costs
LOOP_FLAG NUMBER

Indicates whether a loop is detected
PLANNING_FACTOR NUMBER

Factor used to multiply component quantity with to obtain planning quantity
OPERATION_SEQ_NUM NUMBER

Operation sequence number
BOM_ITEM_TYPE NUMBER

Type of item
PARENT_BOM_ITEM_TYPE NUMBER

Parent item's bom item type
ASSEMBLY_ITEM_ID NUMBER

Assembly item identifier
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
WIP_SUPPLY_TYPE NUMBER

Supply type
ITEM_NUM NUMBER

Item sequence within bill of material structure
EFFECTIVITY_DATE DATE

Effective date
DISABLE_DATE DATE

Disable date
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
IMPLEMENTATION_DATE DATE

Date on which engineering change order was implemented
OPTIONAL NUMBER

Flag indicating if component is optional in bill of material
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator identifier
COMPONENT_REMARKS VARCHAR2 (240)
Component remarks
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
OPERATION_LEAD_TIME_PERCENT NUMBER

Operation offset from first operation in routing
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER

Flag indicating if one or more children of component can be picked when taking an order
CHECK_ATP NUMBER

Flag indicating if ATP check is required
REQUIRED_TO_SHIP NUMBER

Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE NUMBER

Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS NUMBER

Flag indicating if component is included on shipping documents
LOW_QUANTITY NUMBER

Minimum quantity allowed on an order
HIGH_QUANTITY NUMBER

Maximum quantity allowed on an order
SO_BASIS NUMBER

Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPERATION_OFFSET NUMBER

CURRENT_REVISION VARCHAR2 (3)
LOCATOR VARCHAR2 (40)
CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
OBJ_NAME VARCHAR2 (30)
PK1_VALUE VARCHAR2 (240)
PK2_VALUE VARCHAR2 (240)
PK3_VALUE VARCHAR2 (240)
PK4_VALUE VARCHAR2 (240)
PK5_VALUE VARCHAR2 (240)
FROM_END_ITEM_REV_ID NUMBER

FROM_END_ITEM_MINOR_REV_ID NUMBER

From End Item Minor Rev Id
TO_END_ITEM_REV_ID NUMBER

TO_END_ITEM_MINOR_REV_ID NUMBER

To End Item Minor Rev Id
NEW_COMPONENT_CODE VARCHAR2 (4000)
PARENT_SORT_ORDER VARCHAR2 (2000)
COMP_COMMON_BILL_SEQ_ID NUMBER

COMP_BILL_SEQ_ID NUMBER

ACCESS_FLAG VARCHAR2 (1)
ASSEMBLY_TYPE NUMBER

REVISION_LABEL VARCHAR2 (260)
REVISION_ID NUMBER

EFFECTIVITY_CONTROL NUMBER

OBJECT_REVISION_ID NUMBER

MINOR_REVISION_ID NUMBER

MINOR_REVISION_CODE VARCHAR2 (30)
FROM_OBJECT_REVISION_ID NUMBER

From Object Revision Id
FROM_MINOR_REVISION_ID NUMBER

From Minor Revision Id
TO_OBJECT_REVISION_ID NUMBER

To Object Revision Id
TO_MINOR_REVISION_ID NUMBER

To Minor Revision Id
COMPONENT_ITEM_REVISION_ID NUMBER

Item revision Identifier
COMPONENT_MINOR_REVISION_ID NUMBER

BOM_IMPLEMENTATION_DATE DATE

Query Text

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


SELECT TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COMMON_BILL_SEQUENCE_ID
,      COMMON_ORGANIZATION_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      COMPONENT_QUANTITY
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      SORT_ORDER
,      GROUP_ID
,      TOP_ALTERNATE_DESIGNATOR
,      COMPONENT_YIELD_FACTOR
,      TOP_ITEM_ID
,      COMPONENT_CODE
,      INCLUDE_IN_ROLLUP_FLAG
,      LOOP_FLAG
,      PLANNING_FACTOR
,      OPERATION_SEQ_NUM
,      BOM_ITEM_TYPE
,      PARENT_BOM_ITEM_TYPE
,      ASSEMBLY_ITEM_ID
,      ALTERNATE_BOM_DESIGNATOR
,      WIP_SUPPLY_TYPE
,      ITEM_NUM
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      IMPLEMENTATION_DATE
,      OPTIONAL
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      COMPONENT_REMARKS
,      CHANGE_NOTICE
,      OPERATION_LEAD_TIME_PERCENT
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      CHECK_ATP
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      SO_BASIS
,      OPERATION_OFFSET
,      CURRENT_REVISION
,      LOCATOR
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      FROM_END_ITEM_REV_ID
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      NEW_COMPONENT_CODE
,      PARENT_SORT_ORDER
,      COMP_COMMON_BILL_SEQ_ID
,      COMP_BILL_SEQ_ID
,      ACCESS_FLAG
,      ASSEMBLY_TYPE
,      REVISION_LABEL
,      REVISION_ID
,      EFFECTIVITY_CONTROL
,      OBJECT_REVISION_ID
,      MINOR_REVISION_ID
,      MINOR_REVISION_CODE
,      FROM_OBJECT_REVISION_ID
,      FROM_MINOR_REVISION_ID
,      TO_OBJECT_REVISION_ID
,      TO_MINOR_REVISION_ID
,      COMPONENT_ITEM_REVISION_ID
,      COMPONENT_MINOR_REVISION_ID
,      BOM_IMPLEMENTATION_DATE
FROM APPS.BOM_PLM_EXPLOSION_TEMP;

Dependencies

[top of page]

APPS.BOM_PLM_EXPLOSION_TEMP references the following:

SchemaAPPS
SynonymBOM_EXPLOSION_TEMP

APPS.BOM_PLM_EXPLOSION_TEMP is not referenced by any database object