View: GMF_LOT_COSTS_V

Product:	GMF - Process Manufacturing Financials
Description:	Internal View for the lot item cost details form
Implementation/DBA Data:	APPS.GMF_LOT_COSTS_V

View Text

SELECT DISTINCT DTL.ORGANIZATION_ID
, DTL.INVENTORY_ITEM_ID
, ITEM.ITEM_NUMBER
, ITEM.DESCRIPTION AS ITEM_DESCRIPTION
, ITEM.PRIMARY_UOM_CODE
, DTL.COST_TYPE_ID
, MTHD.COST_MTHD_CODE
, MTHD.COST_MTHD_DESC
, NVL(DTL.LOT_NUMBER
, ' ') AS LOT_NUMBER
, GFP.BASE_CURRENCY_CODE AS BASE_CURRENCY
, DTL.HEADER_ID
, DTL.UNIT_COST
, DTL.COST_DATE
, DTL.ONHAND_QTY
, DTL.DELETE_MARK
, RANK () OVER (PARTITION BY DTL.INVENTORY_ITEM_ID
, DTL.ORGANIZATION_ID
, DTL.COST_TYPE_ID
, DTL.LOT_NUMBER ORDER BY COST_DATE DESC
, DTL.HEADER_ID DESC) LOT_COST_RANK
, DTL.FINAL_COST_FLAG
FROM GMF_FISCAL_POLICIES GFP
, CM_MTHD_MST MTHD
, MTL_ITEM_FLEXFIELDS ITEM
, GMF_LOT_COSTS 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