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


VIEW: APPS.MSD_SR_CMRO_PLAN_HIST_V

Object Details
Object Name: MSD_SR_CMRO_PLAN_HIST_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


CMRO Unplanned Service History


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

Organization Source Primary Key
INV_ORG VARCHAR2 (0)
Organization Name
SR_ITEM_PK NUMBER

Product Source Primary Key
ITEM VARCHAR2 (0)
Item
QUANTITY NUMBER

Quantity
REQUESTED_DATE DATE
Yes Replacement Date
SCHEDULED_DATE DATE

Install Base Trackable
Query Text

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


SELECT SR_INV_ORG_PK
,      INV_ORG
,      SR_ITEM_PK
,      ITEM
,      QUANTITY
,      REQUESTED_DATE
,      SCHEDULED_DATE
FROM APPS.MSD_SR_CMRO_PLAN_HIST_V;

Dependencies

[top of page]

APPS.MSD_SR_CMRO_PLAN_HIST_V references the following:

SchemaAPPS
SynonymAHL_SCHEDULE_MATERIALS
SynonymAHL_VISITS_B
SynonymAHL_VISIT_TASKS_B
SynonymMSD_APP_INSTANCE_ORGS
SynonymMSD_SETUP_PARAMETERS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS

APPS.MSD_SR_CMRO_PLAN_HIST_V is not referenced by any database object