[Home] [Help]
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
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
ITEM_NUMBER |
ITEM_DESCRIPTION |
PRIMARY_UOM_CODE |
COST_TYPE_ID |
COST_MTHD_CODE |
COST_MTHD_DESC |
BASE_CURRENCY |
LOT_NUMBER |