View: GMF_LOT_COST_BURDENS_V

Product:	GMF - Process Manufacturing Financials
Description:	View for lot cost burdens form
Implementation/DBA Data:	APPS.GMF_LOT_COST_BURDENS_V

View Text

SELECT DISTINCT DTL.ORGANIZATION_ID
, DTL.INVENTORY_ITEM_ID
, ITEM.ITEM_NUMBER
, ITEM.DESCRIPTION
, ITEM.PRIMARY_UOM_CODE
, DTL.COST_TYPE_ID
, MTHD.COST_MTHD_CODE
, MTHD.COST_MTHD_DESC
, GFP.BASE_CURRENCY_CODE BASE_CURRENCY
, NVL(DTL.LOT_NUMBER
, ' ') AS LOT_NUMBER
FROM GMF_FISCAL_POLICIES GFP
, CM_MTHD_MST MTHD
, MTL_ITEM_FLEXFIELDS ITEM
, GMF_LOT_COST_BURDENS DTL
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE ITEM.INVENTORY_ITEM_ID = DTL.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = DTL.ORGANIZATION_ID
AND MTHD.COST_TYPE_ID = DTL.COST_TYPE_ID
AND OOD.ORGANIZATION_ID = DTL.ORGANIZATION_ID
AND OOD.LEGAL_ENTITY = GFP.LEGAL_ENTITY_ID

Columns