[Home] [Help] [Dependency Information]

TABLE: MTH.MTH_PRODUCTION_SEGMENTS_STG

Object Details

Object Name:	MTH_PRODUCTION_SEGMENTS_STG
Object Type:	TABLE
Owner:	MTH
FND Design Data:	MTH.MTH_PRODUCTION_SEGMENTS_STG
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:
PCT Used:

Columns

Query Text

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

SELECT WORKORDER_FK
,      SEGMENT_PK
,      ITEM_FK
,      START_QUANTITY_G
,      START_QUANTITY_SG
,      PRIMARY_UOM
,      SECONDARY_UOM
,      ACTUAL_COMP_QTY_G
,      ACTUAL_COMP_QTY_SG
,      ACTUAL_REJECTED_QTY_G
,      ACTUAL_REWORKED_QTY_G
,      ACTUAL_SCRAP_QTY_G
,      ACTUAL_REJECTED_QTY_SG
,      ACTUAL_REWORKED_QTY_SG
,      ACTUAL_SCRAP_QTY_SG
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      SYSTEM_FK
,      SEGMENT_STATUS
,      PLANNED_START_DATE
,      PLANNED_COMPLETION_DATE
,      REQ_COMPLETION_DATE
,      USER_DIM1_FK
,      USER_DIM2_FK
,      USER_DIM3_FK
,      USER_DIM4_FK
,      USER_DIM5_FK
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      PROCESSING_FLAG
FROM MTH.MTH_PRODUCTION_SEGMENTS_STG;

Dependencies

[top of page]

MTH.MTH_PRODUCTION_SEGMENTS_STG does not reference any database object

MTH.MTH_PRODUCTION_SEGMENTS_STG is referenced by following:

MTH

MTH_PRODUCTION_SEGMENTS_STG#