VIEW: APPS.GR_INV_FORMULA_V1

Source

View Text - Preformatted

SELECT DISTINCT M.FORMULA_NO FORMULA_NO, I.SEGMENT1 ITEM_NO, O.NAME ORGN_NAME , MP.ORGANIZATION_CODE FROM FM_FORM_MST M, FM_MATL_DTL D, MTL_SYSTEM_ITEMS I, GMD_STATUS S, HR_ALL_ORGANIZATION_UNITS O , MTL_PARAMETERS MP WHERE S.STATUS_CODE = M.FORMULA_STATUS AND M.DELETE_MARK = 0 AND D.FORMULA_ID = M.FORMULA_ID AND D.LINE_TYPE = 1 AND D.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID AND D.ORGANIZATION_ID = I.ORGANIZATION_ID AND I.ORGANIZATION_ID = O.ORGANIZATION_ID AND MP.ORGANIZATION_ID = O.ORGANIZATION_ID

View Text - HTML Formatted

SELECT DISTINCT M.FORMULA_NO FORMULA_NO
, I.SEGMENT1 ITEM_NO
, O.NAME ORGN_NAME
, MP.ORGANIZATION_CODE
FROM FM_FORM_MST M
, FM_MATL_DTL D
, MTL_SYSTEM_ITEMS I
, GMD_STATUS S
, HR_ALL_ORGANIZATION_UNITS O
, MTL_PARAMETERS MP
WHERE S.STATUS_CODE = M.FORMULA_STATUS
AND M.DELETE_MARK = 0
AND D.FORMULA_ID = M.FORMULA_ID
AND D.LINE_TYPE = 1
AND D.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND D.ORGANIZATION_ID = I.ORGANIZATION_ID
AND I.ORGANIZATION_ID = O.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = O.ORGANIZATION_ID