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

VIEW: APPS.PMITS_ROUTING_MASTER_V

Object Details
Object Name: PMITS_ROUTING_MASTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMITS_ROUTING_MASTER_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROUTING_ID NUMBER

Routing ID
ROUTING_NO CHAR (3)
Routing Number
ROUTING_VERS NUMBER

Routing Version
ROUTING_CLASS CHAR (3)
Routing Class
ROUTING_QTY NUMBER

Routing Quantity
ROUTING_STATUS CHAR (3)
Routing Status
ROUTING_DESC CHAR (3)
Routing Description
ITEM_UM CHAR (3)
Item UOM
DELETE_MARK NUMBER

Delete Mark
TEXT_CODE NUMBER

Text Code
INACTIVE_IND CHAR (3)
Inactive Indicator
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
OWNER_ID NUMBER

Owner ID
PROJECT_ID NUMBER

Project ID
PROCESS_LOSS NUMBER

Process Loss
OWNER CHAR (3)
Owner Name
DESCRIPTION CHAR (3)
Owner Display Name
OWNER_ORGN_CODE CHAR (3)
Owner Organization Code
ROUTING_CLASS_DESC CHAR (3)
Routing Class Description
STATUS CHAR (3)
Routing Status
Query Text

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


SELECT ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERS
,      ROUTING_CLASS
,      ROUTING_QTY
,      ROUTING_STATUS
,      ROUTING_DESC
,      ITEM_UM
,      DELETE_MARK
,      TEXT_CODE
,      INACTIVE_IND
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OWNER_ID
,      PROJECT_ID
,      PROCESS_LOSS
,      OWNER
,      DESCRIPTION
,      OWNER_ORGN_CODE
,      ROUTING_CLASS_DESC
,      STATUS
FROM APPS.PMITS_ROUTING_MASTER_V;

Dependencies

[top of page]

APPS.PMITS_ROUTING_MASTER_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_ROUTING_MASTER_V is not referenced by any database object