[Home] [Help] [Dependency Information]
Object Name: | PMITS_FORMULA_MASTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_FORMULA_MASTER_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
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 |
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;
APPS.PMITS_FORMULA_MASTER_V is not referenced by any database object
|
|
|