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