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

TABLE: MTH.MTH_RESOURCE_TXN_STG

Object Details
Object Name: MTH_RESOURCE_TXN_STG
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_RESOURCE_TXN_STG
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKORDER_FK VARCHAR2 (240) Yes
RESOURCE_FK VARCHAR2 (120) Yes
PRODUCT_FK VARCHAR2 (120)
SEGMENT_FK VARCHAR2 (120)
USAGE_QTY NUMBER

USAGE_UOM VARCHAR2 (5)
TRANSACTION_DATE DATE
Yes
SOURCE_ORG_CODE VARCHAR2 (120)
SYSTEM_FK VARCHAR2 (120)
USER_DIM1_FK VARCHAR2 (120)
USER_DIM2_FK VARCHAR2 (120)
USER_DIM3_FK VARCHAR2 (120)
USER_DIM4_FK VARCHAR2 (120)
USER_DIM5_FK VARCHAR2 (120)
USER_ATTR1 VARCHAR2 (150)
USER_ATTR2 VARCHAR2 (150)
USER_ATTR3 VARCHAR2 (150)
USER_ATTR4 VARCHAR2 (150)
USER_ATTR5 VARCHAR2 (150)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

SUB_SEGMENT_FK VARCHAR2 (120)
PROCESSING_FLAG NUMBER

Query Text

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


SELECT WORKORDER_FK
,      RESOURCE_FK
,      PRODUCT_FK
,      SEGMENT_FK
,      USAGE_QTY
,      USAGE_UOM
,      TRANSACTION_DATE
,      SOURCE_ORG_CODE
,      SYSTEM_FK
,      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
,      SUB_SEGMENT_FK
,      PROCESSING_FLAG
FROM MTH.MTH_RESOURCE_TXN_STG;

Dependencies

[top of page]

MTH.MTH_RESOURCE_TXN_STG does not reference any database object

MTH.MTH_RESOURCE_TXN_STG is referenced by following:

SchemaAPPS
SynonymMTH_RESOURCE_TXN_STG