View: PMITS_FORMULA_MASTER_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	GMD Formula Master View
Implementation/DBA Data:	APPS.PMITS_FORMULA_MASTER_V

View Text

SELECT FMV.FORMULA_ID
, FMV.FORMULA_DESC1
, FMV.FORMULA_DESC2
, FMV.FORMULA_NO
, FMV.FORMULA_VERS
, FRMTY_LKP.MEANING AS FORMULA_TYPE
, SCATY_LKP.MEANING AS SCALE_TYPE
, FMV.FORMULA_CLASS
, FMV.FMCONTROL_CLASS
, ACTND_LKP.MEANING AS INACTIVE_IND
, FMV.ORGN_CODE
, FMV.TEXT_CODE
, FMV.DELETE_MARK
, FMV.PROJECT_ID
, FMV.FORMULA_STATUS
, FMV.OWNER_ID
, FMV.TOTAL_INPUT_QTY
, FMV.TOTAL_OUTPUT_QTY
, FMV.FORMULA_UOM
, FU.USER_NAME AS OWNER
, FU.DESCRIPTION AS OWNER_DESC
, GS.MEANING AS STATUS
, FC.FORMULA_CLASS_DESC
, OM.ORGN_NAME AS ORGN_DESC
FROM FM_FORM_MST_VL FMV
, FND_USER FU
, GMD_STATUS GS
, FM_FORM_CLS FC
, SY_ORGN_MST OM
, GEM_LOOKUPS FRMTY_LKP
, GEM_LOOKUPS ACTND_LKP
, GEM_LOOKUPS SCATY_LKP
WHERE FMV.OWNER_ID = FU.USER_ID
AND FMV.FORMULA_STATUS = GS.STATUS_CODE
AND FMV.FORMULA_CLASS = FC.FORMULA_CLASS(+)
AND FMV.ORGN_CODE = OM.ORGN_CODE
AND FRMTY_LKP.LOOKUP_TYPE = 'GME_YES_NO'
AND FRMTY_LKP.LOOKUP_CODE = FMV.FORMULA_TYPE
AND ACTND_LKP.LOOKUP_TYPE = 'GME_YES_NO'
AND ACTND_LKP.LOOKUP_CODE = FMV.INACTIVE_IND
AND SCATY_LKP.LOOKUP_TYPE = 'GME_YES_NO'
AND SCATY_LKP.LOOKUP_CODE = FMV.SCALE_TYPE
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(OM.ORGN_CODE)

Columns