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

VIEW: APPS.BOM_IMPLOSIONS_V

Object Details
Object Name: BOM_IMPLOSIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_IMPLOSIONS_V
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
ROW_ID ROWID (10)
Row identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
SEQUENCE_ID NUMBER
Yes Sequence id
LOWEST_ITEM_ID NUMBER
Yes Identifier of item to implode
COMPONENT_ITEM_ID NUMBER
Yes Component item id
SORT_CODE VARCHAR2 (240) Yes Sort sequence
CURRENT_LEVEL NUMBER
Yes Implosion level
PARENT_ITEM_ID NUMBER

Assembly item identifier
ORGANIZATION_ID NUMBER

Organization identifier
PARENT VARCHAR2 (40)
Parent item
PARENT_DESCRIPTION VARCHAR2 (240)
Parent description
PARENT_UOM VARCHAR2 (3)
Parent unit of measure
ITEM_TYPE VARCHAR2 (80)
Item type
PARENT_ALTERNATE_DESIGNATOR VARCHAR2 (10)
Parent alternate BOM designator
COMPONENT_OP_SEQ_NUM NUMBER

Component operation sequence number
COMPONENT_REVISION VARCHAR2 (3) Yes Component revision
BASIS_TYPE VARCHAR2 (80)
Basis type identifier
COMPONENT_QUANTITY NUMBER

Component quantity
PARENT_ENGINEERING_BILL NUMBER

Parent engineering bill
CHANGE_NOTICE VARCHAR2 (10)
Change notice
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised item sequence identifier
IMPLEMENTED_FLAG NUMBER

Implemented flag
ITEM_STATUS VARCHAR2 (10) Yes Item status
COMPONENT_EFFECTIVE_FROM VARCHAR2 (80)
Component effective from
COMPONENT_EFFECTIVE_TO VARCHAR2 (80)
Component effective to date
EFFECTIVITY_CONTROL VARCHAR2 (80) Yes Effectivity control
DISABLED_FLAG NUMBER

DIsabled flag
ORG_NAME VARCHAR2 (240) Yes Organization name
COMPONENT_NAME VARCHAR2 (40)
Component name
COMPONENT_DESCRIPTION VARCHAR2 (240)
Component description
REVISION_LABEL VARCHAR2 (80)
Revision label
STRUCTURE_TYPE_NAME VARCHAR2 (30)
Structure type name
ITEM_CATALOG_GROUP_NAME VARCHAR2 (4000)
Item catalog group name
CHANGE_ID NUMBER

Engineering change identifier
PARENT_SORT_CODE VARCHAR2 (240)
Sort sequence of parent
LIFECYCLE_ID NUMBER

Lifecycle identifier
CURRENT_PHASE_ID NUMBER

Current phase identifier
TOP_ITEM_FLAG VARCHAR2 (1)
indicating the topmost item in the BOM
PK1_VALUE VARCHAR2 (50)
Primary key of the object
PK2_VALUE VARCHAR2 (50)
Primary key of the object
OBJ_NAME VARCHAR2 (50)
Object name
CURRENT_PK1_VALUE VARCHAR2 (50)
Primary key
CURRENT_PK2_VALUE VARCHAR2 (50)
Primary key
REVISION_ID NUMBER
Yes Revision id
GTIN_NUMBER VARCHAR2 (255)
Gtin Number
GTIN_DESCRIPTION VARCHAR2 (240)
Gtin Description
TRADE_ITEM_DESCRIPTOR VARCHAR2 (150)
Trade Item Descriptor
COMPONENT_SEQUENCE_ID NUMBER

Component Sequence Id
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
STRUCTURE_TYPE_ID NUMBER

Structure Type id
STRUCTURE_TYPE_DISP_NAME VARCHAR2 (80)
Structure Type Display Name
PRIMARY_UOM_DESCRIPTOR VARCHAR2 (50)
Primary UOM Description
STRUCTURE_NAME VARCHAR2 (4000)
Structure nam,e
GTIN_PUBLICATION_STATUS CHAR (1)
GTIN publication status
ACCESS_FLAG VARCHAR2 (1)
View Privilege
REVISION VARCHAR2 (3) Yes Revision
COMP_REVISION_ON_IMPL_DATE VARCHAR2 (80)
Component revision on implementation date
IS_EXCLUDED_BY_RULE VARCHAR2 (1)
Is excluded by rule
COMP_REVCODE_ON_IMPL_DATE VARCHAR2 (3) Yes COmponent revision code in implementation date
REVISION_CODE VARCHAR2 (3)
Revision code
Query Text

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


SELECT ROW_ID
,      ORGANIZATION_CODE
,      SEQUENCE_ID
,      LOWEST_ITEM_ID
,      COMPONENT_ITEM_ID
,      SORT_CODE
,      CURRENT_LEVEL
,      PARENT_ITEM_ID
,      ORGANIZATION_ID
,      PARENT
,      PARENT_DESCRIPTION
,      PARENT_UOM
,      ITEM_TYPE
,      PARENT_ALTERNATE_DESIGNATOR
,      COMPONENT_OP_SEQ_NUM
,      COMPONENT_REVISION
,      BASIS_TYPE
,      COMPONENT_QUANTITY
,      PARENT_ENGINEERING_BILL
,      CHANGE_NOTICE
,      REVISED_ITEM_SEQUENCE_ID
,      IMPLEMENTED_FLAG
,      ITEM_STATUS
,      COMPONENT_EFFECTIVE_FROM
,      COMPONENT_EFFECTIVE_TO
,      EFFECTIVITY_CONTROL
,      DISABLED_FLAG
,      ORG_NAME
,      COMPONENT_NAME
,      COMPONENT_DESCRIPTION
,      REVISION_LABEL
,      STRUCTURE_TYPE_NAME
,      ITEM_CATALOG_GROUP_NAME
,      CHANGE_ID
,      PARENT_SORT_CODE
,      LIFECYCLE_ID
,      CURRENT_PHASE_ID
,      TOP_ITEM_FLAG
,      PK1_VALUE
,      PK2_VALUE
,      OBJ_NAME
,      CURRENT_PK1_VALUE
,      CURRENT_PK2_VALUE
,      REVISION_ID
,      GTIN_NUMBER
,      GTIN_DESCRIPTION
,      TRADE_ITEM_DESCRIPTOR
,      COMPONENT_SEQUENCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STRUCTURE_TYPE_ID
,      STRUCTURE_TYPE_DISP_NAME
,      PRIMARY_UOM_DESCRIPTOR
,      STRUCTURE_NAME
,      GTIN_PUBLICATION_STATUS
,      ACCESS_FLAG
,      REVISION
,      COMP_REVISION_ON_IMPL_DATE
,      IS_EXCLUDED_BY_RULE
,      COMP_REVCODE_ON_IMPL_DATE
,      REVISION_CODE
FROM APPS.BOM_IMPLOSIONS_V;

Dependencies

[top of page]

APPS.BOM_IMPLOSIONS_V references the following:

SchemaAPPS
SynonymBOM_ALTERNATE_DESIGNATORS_TL
PL/SQL PackageBOM_GLOBALS - show dependent code
SynonymBOM_SMALL_IMPL_TEMP
ViewBOM_STRUCTURE_TYPES_VL
ViewEGO_ITEMS_V
SynonymENG_ENGINEERING_CHANGES
PL/SQL PackageFND_FLEX_SERVER - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_ITEM_CATALOG_GROUPS
SynonymMTL_ITEM_REVISIONS_B
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL
APPS.BOM_IMPLOSIONS_V is referenced by following:

SchemaAPPS
Package BodyBOM_ROLLUP_PUB - show dependent code