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

VIEW: MTH.MTH_RESOURCE_TXN_STG#

Object Details
Object Name: MTH_RESOURCE_TXN_STG#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

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# references the following:

SchemaMTH
TableMTH_RESOURCE_TXN_STG
MTH.MTH_RESOURCE_TXN_STG# is referenced by following:

SchemaAPPS
SynonymMTH_RESOURCE_TXN_STG