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

VIEW: APPS.PMITS_OPERATION_MASTER_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPRN_ID NUMBER

Operation ID
OPRN_NO CHAR (3)
Operation Number
OPRN_VERS NUMBER

Operation Version
PROCESS_QTY_UM CHAR (3)
Process Quantity UOM
OPRN_CLASS CHAR (3)
Operation Class
POC_CTL_CLASS CHAR (3)
Procedure Control Class
INACTIVE_IND NUMBER

Inactive Indicator
DELETE_MARK NUMBER

Delete Mark
TEXT_CODE NUMBER

Text Code
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
OPERATION_STATUS CHAR (3)
Operation Status
OWNER_ORGN_CODE CHAR (3)
Owner Ognization Code
OPRN_DESC CHAR (3)
Operation Description
ORGN_NAME CHAR (3)
Organization Name
OPRN_CLASS_DESC CHAR (3)
Operation Class Description
STATUS CHAR (3)
Operation Status
Query Text

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


SELECT OPRN_ID
,      OPRN_NO
,      OPRN_VERS
,      PROCESS_QTY_UM
,      OPRN_CLASS
,      POC_CTL_CLASS
,      INACTIVE_IND
,      DELETE_MARK
,      TEXT_CODE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OPERATION_STATUS
,      OWNER_ORGN_CODE
,      OPRN_DESC
,      ORGN_NAME
,      OPRN_CLASS_DESC
,      STATUS
FROM APPS.PMITS_OPERATION_MASTER_V;

Dependencies

[top of page]

APPS.PMITS_OPERATION_MASTER_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_OPERATION_MASTER_V is not referenced by any database object