View: GMF_XLA_LOTCOST_ADJS_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from Lot Cost Adjustments View
Implementation/DBA Data:	APPS.GMF_XLA_LOTCOST_ADJS_V

View Text

SELECT EH.REFERENCE_NO
, EH.LEDGER_ID
, EH.TRANSACTION_ID
, EH.EVENT_CLASS_CODE
, EH.OPERATING_UNIT
, LCA.ADJUSTMENT_ID
, LCA.ADJUSTMENT_DATE
, EH.TRANSACTION_QUANTITY ||' '|| MSI.PRIMARY_UOM_CODE AS PRIMARY_QUANTITY
, MSI.PRIMARY_UOM_CODE
, MSI.SECONDARY_UOM_CODE
, EH.TRANSACTION_UOM
, EH.SOURCE_DOCUMENT_ID
, EH.SOURCE_LINE_ID
, LCA.LOT_NUMBER
, LCA.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS AS ITEM_NUMBER
, MSI.DESCRIPTION AS ITEM_DESCRIPTION
, LCA.LEGAL_ENTITY_ID
, LE.NAME AS LEGAL_ENTITY_NAME
, LCA.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, EH.VALUATION_COST_TYPE_ID
, EH.VALUATION_COST_TYPE
, LCA.REASON_CODE
, DECODE(LCA.APPLIED_IND
, 'Y'
, 'APPLIED'
, 'NOT APPLIED') AS APPLIED_IND
, DECODE(LCA.GL_POSTED_IND
, 1
, 'POSTED TO GL'
, 'NOT POSTED TO GL') AS GL_POSTED_IND
FROM GMF_XLA_EXTRACT_HEADERS EH
, GMF_LOT_COST_ADJUSTMENTS LCA
, MTL_SYSTEM_ITEMS_B_KFV MSI
, XLE_ENTITY_PROFILES LE
, MTL_PARAMETERS MP
WHERE EH.LEGAL_ENTITY_ID = LCA.LEGAL_ENTITY_ID
AND EH.TRANSACTION_ID = LCA.ADJUSTMENT_ID
AND EH.SOURCE_DOCUMENT_ID = LCA.ADJUSTMENT_ID
AND EH.SOURCE_LINE_ID = LCA.INVENTORY_ITEM_ID
AND LCA.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = LCA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = LCA.ORGANIZATION_ID
AND LE.LEGAL_ENTITY_ID = LCA.LEGAL_ENTITY_ID
AND EH.EVENT_CLASS_CODE = 'LOTCOSTADJ'

Columns