View: GMF_XLA_ACTCOST_ADJS_V

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

View Text

SELECT EH.LEDGER_ID
, EH.TRANSACTION_ID
, EH.VALUATION_COST_TYPE_ID
, EH.VALUATION_COST_TYPE
, EH.EVENT_CLASS_CODE
, LE.NAME LEGAL_ENTITY_NAME
, MSI.CONCATENATED_SEGMENTS AS ITEM_NAME
, MSI.DESCRIPTION AS ITEM_DESCRIPTION
, MP.ORGANIZATION_CODE
, ADJS.ADJUSTMENT_DATE
, EH.TRANSACTION_QUANTITY ||' '|| MSI.PRIMARY_UOM_CODE AS PRIMARY_QUANTITY
, EH.TRANSACTION_UOM
, MSI.PRIMARY_UOM_CODE
, MSI.SECONDARY_UOM_CODE
, ADJS.REASON_CODE
, REAS.REASON_DESC AS REASON_DESCRIPTION
, GPS.CALENDAR_CODE
, GPS.PERIOD_CODE
, ADJS.ADJUST_COST AS ADJUSTMENT_COST
, DECODE(GPS.PERIOD_STATUS
, 'O'
, 'OPEN'
, 'F'
, 'FROZEN'
, 'C'
, 'CLOSED') PERIOD_STATUS
, DECODE(ADJS.ADJUST_STATUS
, 0
, 'NOT APPLIED'
, 1
, 'APPLIED'
, 2
, 'MODIFIED') ADJUSTMENT_STATUS
, DECODE(ADJS.ADJUSTMENT_IND
, 0
, 'AVERAGE ADJUSTMENT'
, 1
, 'VALUE ADJUSTMENT'
, 2
, 'UNIT ADJUSTMENT') ADJUSTMENT_INDICATOR
FROM GMF_XLA_EXTRACT_HEADERS EH
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_B_KFV MSI
, CM_ADJS_DTL ADJS
, XLE_ENTITY_PROFILES LE
, GMF_PERIOD_STATUSES GPS
, CM_REAS_CDS REAS
WHERE EH.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = EH.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = EH.INVENTORY_ITEM_ID
AND ADJS.COST_ADJUST_ID = EH.TRANSACTION_ID
AND LE.LEGAL_ENTITY_ID = EH.LEGAL_ENTITY_ID
AND GPS.PERIOD_ID = ADJS.PERIOD_ID
AND EH.EVENT_CLASS_CODE = 'ACTCOSTADJ'
AND REAS.REASON_CODE = ADJS.REASON_CODE

Columns