[Home] [Help] [Dependency Information]
Object Name: | MSC_SETUP_TRANSITION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
PLAN_ID | NUMBER | Yes | Plan Id | |
SR_INSTANCE_ID | NUMBER | Yes | Sr Instance Id | |
RESOURCE_ID | NUMBER | Yes | Resource Id | |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
DEPARTMENT_ID | NUMBER | Yes | Department Id | |
FROM_SETUP_ID | NUMBER | From Setup Id | ||
TO_SETUP_ID | NUMBER | Yes | To Setup Id | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Department Code | |
RESOURCE_CODE | VARCHAR2 | (16) | Resource Code | |
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
SETUP_TYPE_FROM | VARCHAR2 | (100) | Setup Type From | |
SETUP_TYPE_TO | VARCHAR2 | (100) | Setup Type To | |
TRANSITION_TIME | NUMBER | Yes | Transition Time | |
TRANSITION_UOM | VARCHAR2 | (3) | Yes | Transition Uom |
TRANSITION_PENALTY | NUMBER | Transition Penalty | ||
STANDARD_OPERATION_CODE | VARCHAR2 | (4000) | Standard Operation Code | |
RING_SEQUENCE_NUMBER | NUMBER | Ring Sequence Number | ||
ORIG_TRANSITION_TIME | NUMBER | Orig Transition Time |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PLAN_ID
, SR_INSTANCE_ID
, RESOURCE_ID
, ORGANIZATION_ID
, DEPARTMENT_ID
, FROM_SETUP_ID
, TO_SETUP_ID
, DEPARTMENT_CODE
, RESOURCE_CODE
, ORGANIZATION_CODE
, SETUP_TYPE_FROM
, SETUP_TYPE_TO
, TRANSITION_TIME
, TRANSITION_UOM
, TRANSITION_PENALTY
, STANDARD_OPERATION_CODE
, RING_SEQUENCE_NUMBER
, ORIG_TRANSITION_TIME
FROM APPS.MSC_SETUP_TRANSITION_V;
APPS.MSC_SETUP_TRANSITION_V is not referenced by any database object
|
|
|