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

VIEW: APPS.PMITS_FORMULA_MASTER_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
FORMULA_ID NUMBER

Formula ID
FORMULA_DESC1 CHAR (3)
Formula Description
FORMULA_DESC2 CHAR (3)
Formula Comment
FORMULA_NO CHAR (3)
Formula Number
FORMULA_VERS NUMBER

Formula Version
FORMULA_TYPE CHAR (3)
Formula Packaging Type
SCALE_TYPE CHAR (3)
Scale Allowed Type
FORMULA_CLASS CHAR (3)
Formula Class
FMCONTROL_CLASS CHAR (3)
Formula Control Class
INACTIVE_IND CHAR (3)
Inactive Indicator
ORGN_CODE CHAR (3)
Organization Code
TEXT_CODE NUMBER

Text Code
DELETE_MARK NUMBER

Delete Mark
PROJECT_ID NUMBER

Project ID
FORMULA_STATUS CHAR (3)
Formula Status
OWNER_ID NUMBER

Owner ID
TOTAL_INPUT_QTY NUMBER

Total Input Quantity
TOTAL_OUTPUT_QTY NUMBER

Total Output Quantity
FORMULA_UOM CHAR (3)
Formula UOM
OWNER CHAR (3)
Owner
OWNER_DESC CHAR (3)
Owner Description
STATUS CHAR (3)
Formula Status
FORMULA_CLASS_DESC CHAR (3)
Formula class Description
ORGN_DESC CHAR (3)
Organization Description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FORMULA_ID
,      FORMULA_DESC1
,      FORMULA_DESC2
,      FORMULA_NO
,      FORMULA_VERS
,      FORMULA_TYPE
,      SCALE_TYPE
,      FORMULA_CLASS
,      FMCONTROL_CLASS
,      INACTIVE_IND
,      ORGN_CODE
,      TEXT_CODE
,      DELETE_MARK
,      PROJECT_ID
,      FORMULA_STATUS
,      OWNER_ID
,      TOTAL_INPUT_QTY
,      TOTAL_OUTPUT_QTY
,      FORMULA_UOM
,      OWNER
,      OWNER_DESC
,      STATUS
,      FORMULA_CLASS_DESC
,      ORGN_DESC
FROM APPS.PMITS_FORMULA_MASTER_V;

Dependencies

[top of page]

APPS.PMITS_FORMULA_MASTER_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_FORMULA_MASTER_V is not referenced by any database object