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

VIEW: APPS.BOMBV_MFG_SHIFT_MODIFICATIONS

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

View Type

A Business Intelligence System view


This shows information about capacity modifications for a resource on a shift in a department. Users can make multiple resource modifications for a shift.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SHIFT_NUMBER NUMBER
Yes
RESOURCE_CODE VARCHAR2 (10) Yes
DEPARTMENT_CODE VARCHAR2 (10) Yes
CAPACITY_CHANGE_START_DATE DATE
Yes
CAPACITY_CHANGE_END_DATE DATE


CAPACITY_CHANGE_START_TIME NUMBER


CAPACITY_CHANGE_END_TIME NUMBER


_LA:CAPACITY_CHANGE_TYPE CHAR (46)
SIMULATION_SET VARCHAR2 (10) Yes
CAPACITY_CHANGE NUMBER


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

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


SELECT SHIFT_NUMBER
,      RESOURCE_CODE
,      DEPARTMENT_CODE
,      CAPACITY_CHANGE_START_DATE
,      CAPACITY_CHANGE_END_DATE
,      CAPACITY_CHANGE_START_TIME
,      CAPACITY_CHANGE_END_TIME
,      _LA:CAPACITY_CHANGE_TYPE
,      SIMULATION_SET
,      CAPACITY_CHANGE
,      RESOURCE_ID
,      DEPARTMENT_ID
,      UPDATED_ON
,      UPDATED_BY
,      CREATED_ON
,      CREATED_BY
FROM APPS.BOMBV_MFG_SHIFT_MODIFICATIONS;

Dependencies

[top of page]

APPS.BOMBV_MFG_SHIFT_MODIFICATIONS references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymBOM_RESOURCE_CHANGES

APPS.BOMBV_MFG_SHIFT_MODIFICATIONS is not referenced by any database object