DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PMITS_RECIPE_MASTER_V

Object Details
Object Name: PMITS_RECIPE_MASTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMITS_RECIPE_MASTER_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
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)
Query Text

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;

Dependencies

[top of page]

APPS.PMITS_RECIPE_MASTER_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_RECIPE_MASTER_V is not referenced by any database object