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

VIEW: MSD.MSD_SPF_ST_CMRO_RES_USG#

Object Details
Object Name: MSD_SPF_ST_CMRO_RES_USG#
Object Type: VIEW
Owner: MSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATING_FLEET VARCHAR2 (240)
OPERATING_ORG VARCHAR2 (240)
OPERATING_ORG_DESC VARCHAR2 (240)
OPERATIONS_TYPE_CODE VARCHAR2 (240)
OPERATIONS_TYPE_DESC VARCHAR2 (240)
ORIGINATING_MR VARCHAR2 (240)
VISIT_TYPE VARCHAR2 (240)
TRANSIT_VISIT VARCHAR2 (1)
VISIT_STAGE_TYPE VARCHAR2 (240)
MAINTENANCE_TYPE_CODE VARCHAR2 (240)
MAINTENANCE_TYPE_DESC VARCHAR2 (240)
RESOURCE_SR_PK NUMBER

BOM_RESOURCE_CODE VARCHAR2 (240)
CMRO_RESOURCE_CODE VARCHAR2 (240)
SR_ORG_PK NUMBER

ORG_CODE VARCHAR2 (240)
USG_DATE DATE

QUANTITY NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROCESS_FLAG NUMBER

ERROR_TEXT VARCHAR2 (1024)
Query Text

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


SELECT OPERATING_FLEET
,      OPERATING_ORG
,      OPERATING_ORG_DESC
,      OPERATIONS_TYPE_CODE
,      OPERATIONS_TYPE_DESC
,      ORIGINATING_MR
,      VISIT_TYPE
,      TRANSIT_VISIT
,      VISIT_STAGE_TYPE
,      MAINTENANCE_TYPE_CODE
,      MAINTENANCE_TYPE_DESC
,      RESOURCE_SR_PK
,      BOM_RESOURCE_CODE
,      CMRO_RESOURCE_CODE
,      SR_ORG_PK
,      ORG_CODE
,      USG_DATE
,      QUANTITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROCESS_FLAG
,      ERROR_TEXT
FROM MSD.MSD_SPF_ST_CMRO_RES_USG#;

Dependencies

[top of page]

MSD.MSD_SPF_ST_CMRO_RES_USG# references the following:

SchemaMSD
TableMSD_SPF_ST_CMRO_RES_USG
MSD.MSD_SPF_ST_CMRO_RES_USG# is referenced by following:

SchemaAPPS
SynonymMSD_SPF_ST_CMRO_RES_USG