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


VIEW: APPS.BOM_OPERATIONAL_ROUTINGS_ERV

Object Details
Object Name: BOM_OPERATIONAL_ROUTINGS_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_OPERATIONAL_ROUTINGS_ERV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Rowid of table BOM_OPERATIONAL_ROUTINGS
ORGANIZATION_CODE VARCHAR2 (3)
Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
ITEM_CATEGORY VARCHAR2 (0)
Item Category
ASSEMBLY_ITEM VARCHAR2 (40)
Assembly Item Name
ASSEMBLY_ITEM_DESCRIPTION VARCHAR2 (240)
Assembly Item Description
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit Of Measure
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator
CURRENT_REVISION VARCHAR2 (3) Yes Revision Code of Current Revision
PRIORITY NUMBER

Priority
PRODUCT_FAMILY VARCHAR2 (40)
Name of Product Family
SERIALIZATION_START_OP NUMBER

Serialization Start Operation
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion Sub-Inventory
COMPLETION_LOCATOR CHAR (1)
Completion Locator
ROUTING_COMMENT VARCHAR2 (240)
Routing Comments
COMMON_ROUTING_ITEM VARCHAR2 (40)
Name of Item whose routing we are referencing
COMMON_ROUTING_ITEM_DESC VARCHAR2 (240)
Description of Item whose routing we are referencing
ORGANIZATION_ID NUMBER
Yes Organization identifier
ASSEMBLY_ITEM_ID NUMBER
Yes Assembly Item Id
ROUTING_SEQUENCE_ID NUMBER
Yes Unique Id for Routing
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
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ROUTING_TYPE NUMBER
Yes Type Of Routing
COMMON_ASSEMBLY_ITEM_ID NUMBER

Id of Item whose routing we are referencing
COMMON_ROUTING_SEQUENCE_ID NUMBER
Yes Routing Id of Item whose routing we are referencing
SUB_LOCATOR_CONTROL NUMBER

Locator Control Information
COMPLETION_LOCATOR_ID NUMBER

Locator Identifier
ATTRIBUTE_CATEGORY 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
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
LINE_ID NUMBER

WIP Line Identifier
LINE_CODE VARCHAR2 (10)
WIP Line Code
CFM_ROUTING_FLAG NUMBER

CFM Routing flag
MIXED_MODEL_MAP_FLAG NUMBER

Mixed Model Map Flag
PRODUCT_FAMILY_ITEM_ID NUMBER

Product Family Identifier
PRODUCT_ITEM_NUMBER VARCHAR2 (40)
Product Item Number
CTP_FLAG NUMBER

CTP Flag
TOTAL_PRODUCT_CYCLE_TIME NUMBER

total Product Cycle time
PENDING_FROM_ECN VARCHAR2 (10)
ECO Attribute
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original System Reference
EAM_ITEM_TYPE NUMBER

EAM Item Type
Query Text

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


SELECT ROW_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ITEM_CATEGORY
,      ASSEMBLY_ITEM
,      ASSEMBLY_ITEM_DESCRIPTION
,      PRIMARY_UOM_CODE
,      ALTERNATE_ROUTING_DESIGNATOR
,      CURRENT_REVISION
,      PRIORITY
,      PRODUCT_FAMILY
,      SERIALIZATION_START_OP
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR
,      ROUTING_COMMENT
,      COMMON_ROUTING_ITEM
,      COMMON_ROUTING_ITEM_DESC
,      ORGANIZATION_ID
,      ASSEMBLY_ITEM_ID
,      ROUTING_SEQUENCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROUTING_TYPE
,      COMMON_ASSEMBLY_ITEM_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      SUB_LOCATOR_CONTROL
,      COMPLETION_LOCATOR_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LINE_ID
,      LINE_CODE
,      CFM_ROUTING_FLAG
,      MIXED_MODEL_MAP_FLAG
,      PRODUCT_FAMILY_ITEM_ID
,      PRODUCT_ITEM_NUMBER
,      CTP_FLAG
,      TOTAL_PRODUCT_CYCLE_TIME
,      PENDING_FROM_ECN
,      ORIGINAL_SYSTEM_REFERENCE
,      EAM_ITEM_TYPE
FROM APPS.BOM_OPERATIONAL_ROUTINGS_ERV;

Dependencies

[top of page]

APPS.BOM_OPERATIONAL_ROUTINGS_ERV references the following:

SchemaAPPS
SynonymBOM_OPERATIONAL_ROUTINGS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewMTL_ITEM_FLEXFIELDS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_PARAMETERS
SynonymMTL_RTG_ITEM_REVISIONS
SynonymMTL_SECONDARY_INVENTORIES
ViewMTL_SYSTEM_ITEMS_VL
SynonymWIP_LINES

APPS.BOM_OPERATIONAL_ROUTINGS_ERV is not referenced by any database object