[Home] [Help] [Dependency Information]
Object Name: | PMITS_RECIPE_MASTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_RECIPE_MASTER_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECIPE_ID | NUMBER | Recipe ID | ||
RECIPE_DESCRIPTION | CHAR | (3) | Recipe Description | |
RECIPE_NO | CHAR | (3) | Recipe Number | |
RECIPE_VERSION | NUMBER | Recipe Version | ||
OWNER_ORGN_CODE | CHAR | (3) | Owner Organization Code | |
CREATION_ORGN_CODE | CHAR | (3) | ||
FORMULA_ID | NUMBER | |||
ROUTING_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
RECIPE_STATUS | CHAR | (3) | ||
PLANNED_PROCESS_LOSS | NUMBER | |||
TEXT_CODE | CHAR | (3) | ||
DELETE_MARK | NUMBER | |||
OWNER_ID | NUMBER | |||
OWNER_LAB_TYPE | CHAR | (3) | ||
CALCULATE_STEP_QUANTITY | CHAR | (3) | ||
OWNER | CHAR | (3) | ||
FORMULA_NO | CHAR | (3) | ||
FORMULA_VERS | NUMBER | |||
RECIPE_UOM | CHAR | (3) | ||
TOTAL_OUTPUT_QTY | NUMBER | |||
ROUTING_NO | CHAR | (3) | ||
ROUTING_VERS | NUMBER | |||
PRODUCT | CHAR | (3) | ||
PRODUCT_UOM | CHAR | (3) | ||
PRODUCT_QTY | NUMBER | |||
STATUS | CHAR | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT RECIPE_ID
, RECIPE_DESCRIPTION
, RECIPE_NO
, RECIPE_VERSION
, OWNER_ORGN_CODE
, CREATION_ORGN_CODE
, FORMULA_ID
, ROUTING_ID
, PROJECT_ID
, RECIPE_STATUS
, PLANNED_PROCESS_LOSS
, TEXT_CODE
, DELETE_MARK
, OWNER_ID
, OWNER_LAB_TYPE
, CALCULATE_STEP_QUANTITY
, OWNER
, FORMULA_NO
, FORMULA_VERS
, RECIPE_UOM
, TOTAL_OUTPUT_QTY
, ROUTING_NO
, ROUTING_VERS
, PRODUCT
, PRODUCT_UOM
, PRODUCT_QTY
, STATUS
FROM APPS.PMITS_RECIPE_MASTER_V;
APPS.PMITS_RECIPE_MASTER_V is not referenced by any database object
|
|
|