eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMF_LOT_COST_BURDENS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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