VIEW: APPS.GMF_XLA_ACTCOST_ADJS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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