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


VIEW: APPS.BOMFV_ROUTINGS

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

View Type

A Business Intelligence System view


This shows information about the sequence of manufacturing operations
that are performed to manufacture an assembly.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ALTERNATE_ROUTING_CODE VARCHAR2 (10)

ORGANIZATION_CODE VARCHAR2 (3)

ORGANIZATION_NAME VARCHAR2 (240) Yes
_KF:ITEM_NAME CHAR (15)

TOTAL_CYCLE_TIME NUMBER


ROUTING_PRIORITY NUMBER


COMMENT VARCHAR2 (240)

_LA:ENGINEERING_ROUTING_FLAG CHAR (50)

_LA:MIXED_MODEL_MAP_FLAG CHAR (58)

_LA:CAPABLE_TO_PROMISE_FLAG CHAR (46)

_LA:FLOW_ROUTING_FLAG CHAR (54)

COMMON_ALTERNATE_ROUTING_CODE VARCHAR2 (10)

_KF:COMMON_ROUTING_NAME CHAR (16)

_KF:COMPLETION_LOCATOR_CODE CHAR (15)

LINE_NAME VARCHAR2 (10)

PROJECT_NAME VARCHAR2 (30)

TASK_NAME VARCHAR2 (20)

_DF CHAR (35)
ROUTING_SEQUENCE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
COMMON_ASSEMBLY_ITEM_ID NUMBER


ASSEMBLY_ITEM_ID NUMBER
Yes
COMMON_ROUTING_SEQUENCE_ID NUMBER
Yes
COMPLETION_SUBINVENTORY VARCHAR2 (10)

COMPLETION_LOCATOR_ID NUMBER


LINE_ID NUMBER


PROJECT_ID NUMBER


TASK_ID NUMBER


CREATED_BY NUMBER
Yes
CREATED_ON DATE
Yes
UPDATED_ON DATE
Yes
UPDATED_BY NUMBER
Yes
Query Text

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


SELECT ALTERNATE_ROUTING_CODE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      _KF:ITEM_NAME
,      TOTAL_CYCLE_TIME
,      ROUTING_PRIORITY
,      COMMENT
,      _LA:ENGINEERING_ROUTING_FLAG
,      _LA:MIXED_MODEL_MAP_FLAG
,      _LA:CAPABLE_TO_PROMISE_FLAG
,      _LA:FLOW_ROUTING_FLAG
,      COMMON_ALTERNATE_ROUTING_CODE
,      _KF:COMMON_ROUTING_NAME
,      _KF:COMPLETION_LOCATOR_CODE
,      LINE_NAME
,      PROJECT_NAME
,      TASK_NAME
,      _DF
,      ROUTING_SEQUENCE_ID
,      ORGANIZATION_ID
,      COMMON_ASSEMBLY_ITEM_ID
,      ASSEMBLY_ITEM_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      CREATED_BY
,      CREATED_ON
,      UPDATED_ON
,      UPDATED_BY
FROM APPS.BOMFV_ROUTINGS;

Dependencies

[top of page]

APPS.BOMFV_ROUTINGS references the following:

SchemaAPPS
SynonymBOM_OPERATIONAL_ROUTINGS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymWIP_LINES

APPS.BOMFV_ROUTINGS is not referenced by any database object