[Home] [Help] [Dependency Information]
Object Name: | GMD_MBR_STEP_OPRN_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_MBR_STEP_OPRN_V1 |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_ID | NUMBER | (10) | Yes | Routing ID |
ROUTINGSTEP_NO | NUMBER | (5) | Yes | Routing Step Number |
ROUTINGSTEP_ID | NUMBER | (10) | Yes | Routing Step ID |
OPRN_ID | NUMBER | (10) | Yes | Operation ID |
STEP_QTY | NUMBER | Yes | Quantity processed by the routing step. | |
STEPRELEASE_TYPE | NUMBER | (5) | Yes | Step release type. 0=Automatic, 1=Manual. |
MINIMUM_TRANSFER_QTY | NUMBER | Minimum amount of material that must be produced at a given production operation and resource, that will be transferred to the next operation and resource before it can begin processing | ||
OPRN_NO | VARCHAR2 | (16) | Yes | Alphanumeric operation name or number |
OPRN_VERS | NUMBER | (5) | Yes | Operation version |
PROCESS_QTY_UOM | VARCHAR2 | (3) | Yes | Process qty UOM |
OPRN_CLASS | VARCHAR2 | (4) | Operation class | |
INACTIVE_IND | NUMBER | (5) | Inactive indicator | |
EFFECTIVE_START_DATE | VARCHAR2 | (4000) | Operation effective start date | |
EFFECTIVE_END_DATE | VARCHAR2 | (4000) | Operation effective end date | |
OPERATION_STATUS | VARCHAR2 | (30) | Yes | Operation status |
OWNER_ORGANIZATION_ID | NUMBER | (15) | Yes | Inventory organizaion id |
OPRN_DESC | VARCHAR2 | (40) | Yes | Operation Description |
RECIPE_ID | NUMBER | (15) | Yes | Recipe ID |
ENTITY_KEY | VARCHAR2 | (122) | Entity Key to retrieve Processing Instruction |
Cut, paste (and edit) the following text to query this object:
SELECT ROUTING_ID
, ROUTINGSTEP_NO
, ROUTINGSTEP_ID
, OPRN_ID
, STEP_QTY
, STEPRELEASE_TYPE
, MINIMUM_TRANSFER_QTY
, OPRN_NO
, OPRN_VERS
, PROCESS_QTY_UOM
, OPRN_CLASS
, INACTIVE_IND
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, OPERATION_STATUS
, OWNER_ORGANIZATION_ID
, OPRN_DESC
, RECIPE_ID
, ENTITY_KEY
FROM APPS.GMD_MBR_STEP_OPRN_V1;
APPS.GMD_MBR_STEP_OPRN_V1 is not referenced by any database object
|
|
|