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

VIEW: APPS.MSD_SR_SERVICE_PART_USAGE_V

Object Details
Object Name: MSD_SR_SERVICE_PART_USAGE_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.


CRM Service Part Usage History Data


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRD_LEVEL_ID NUMBER

Product Level Id
PRD_SR_LEVEL_PK NUMBER

Product Source Level Primary Key
ORG_LEVEL_ID NUMBER

Ship From Location Level Id
ORG_SR_LEVEL_PK NUMBER

Ship From Location Source Level Primary Key
GEO_LEVEL_ID NUMBER

Geography Level Id
GEO_SR_LEVEL_PK NUMBER

Geography Source Level Value Primary Key
TIM_LEVEL_ID NUMBER

Time Level Id
REPLACEMENT_DATE DATE

Replacement Date
REPLACEMENT_QTY NUMBER

Replacement Quantity
IB_TRACKABLE VARCHAR2 (1)
Install Base Trackable
SOURCE_APPLICATION VARCHAR2 (30)
Source Application
Query Text

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


SELECT PRD_LEVEL_ID
,      PRD_SR_LEVEL_PK
,      ORG_LEVEL_ID
,      ORG_SR_LEVEL_PK
,      GEO_LEVEL_ID
,      GEO_SR_LEVEL_PK
,      TIM_LEVEL_ID
,      REPLACEMENT_DATE
,      REPLACEMENT_QTY
,      IB_TRACKABLE
,      SOURCE_APPLICATION
FROM APPS.MSD_SR_SERVICE_PART_USAGE_V;

Dependencies

[top of page]

APPS.MSD_SR_SERVICE_PART_USAGE_V references the following:

SchemaAPPS
SynonymCSD_REPAIRS
SynonymCSF_DEBRIEF_HEADERS
SynonymCSF_DEBRIEF_LINES
SynonymCS_INCIDENTS_ALL
SynonymCS_TRANSACTION_TYPES
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTY_SITES
SynonymJTF_TASKS_B
SynonymJTF_TASK_ASSIGNMENTS
SynonymMSD_APP_INSTANCE_ORGS
SynonymMSD_SETUP_PARAMETERS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_SYSTEM_ITEMS
SchemaPUBLIC
SynonymDUAL

APPS.MSD_SR_SERVICE_PART_USAGE_V is not referenced by any database object