[Home] [Help] [Dependency Information]
Object Name: | PMITS_OPERATION_MASTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_OPERATION_MASTER_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
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 |
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;
APPS.PMITS_OPERATION_MASTER_V is not referenced by any database object
|
|
|