VIEW: APPS.GMF_XLA_LC_ADJS_V

Source

View Text - Preformatted

SELECT glat.adj_transaction_id ADJ_TRANSACTION_ID, glat.rcv_transaction_id RCV_TRANSACTION_ID, eh.legal_entity_id LEGAL_ENTITY_ID, eh.ledger_id LEDGER_ID, eh.transaction_id TRANSACTION_ID, eh.valuation_cost_type_id VALUATION_COST_TYPE_ID, eh.valuation_cost_type VALUATION_COST_TYPE, eh.event_class_code EVENT_CLASS_CODE, le.name LEGAL_ENTITY_NAME, msi.concatenated_segments ITEM_NAME, msi.description ITEM_DESCRIPTION, mp.organization_code ORGANIZATION_CODE, eh.transaction_date TRANSACTION_DATE, glat.component_type COMPONENT_TYPE, glat.component_name COMPONENT_NAME, glat.charge_line_type_code CHARGE_LINE_TYPE_CODE, glat.adjustment_num ADJUSTMENT_NUM, eh.transaction_quantity ||' '|| msi.primary_uom_code PRIMARY_QUANTITY, msi.primary_uom_code PRIMARY_UOM_CODE, msi.secondary_uom_code SECONDARY_UOM_CODE, glat.lc_ship_num LC_SHIP_NUM, glat.lc_ship_line_num LC_SHIP_LINE_NUM FROM gmf_lc_adj_transactions glat, gmf_xla_extract_headers eh, mtl_parameters mp, mtl_system_items_b_kfv msi, xle_entity_profiles le WHERE eh.event_type_code IN ('LC_ADJUST_RECEIVE','LC_ADJUST_DELIVER','LC_ADJUST_EXP_DELIVER','LC_ADJUST_VALUATION') AND eh.source_document_id = glat.adj_transaction_id AND eh.source_line_id = glat.rcv_transaction_id AND eh.organization_id = mp.organization_id AND msi.organization_id = eh.organization_id AND msi.inventory_item_id = eh.inventory_item_id AND le.legal_entity_id = eh.legal_entity_id AND eh.event_class_code = 'LC_ADJUSTMENTS'

View Text - HTML Formatted

SELECT GLAT.ADJ_TRANSACTION_ID ADJ_TRANSACTION_ID
, GLAT.RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, EH.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, EH.LEDGER_ID LEDGER_ID
, EH.TRANSACTION_ID TRANSACTION_ID
, EH.VALUATION_COST_TYPE_ID VALUATION_COST_TYPE_ID
, EH.VALUATION_COST_TYPE VALUATION_COST_TYPE
, EH.EVENT_CLASS_CODE EVENT_CLASS_CODE
, LE.NAME LEGAL_ENTITY_NAME
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, EH.TRANSACTION_DATE TRANSACTION_DATE
, GLAT.COMPONENT_TYPE COMPONENT_TYPE
, GLAT.COMPONENT_NAME COMPONENT_NAME
, GLAT.CHARGE_LINE_TYPE_CODE CHARGE_LINE_TYPE_CODE
, GLAT.ADJUSTMENT_NUM ADJUSTMENT_NUM
, EH.TRANSACTION_QUANTITY ||' '|| MSI.PRIMARY_UOM_CODE PRIMARY_QUANTITY
, MSI.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, MSI.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, GLAT.LC_SHIP_NUM LC_SHIP_NUM
, GLAT.LC_SHIP_LINE_NUM LC_SHIP_LINE_NUM
FROM GMF_LC_ADJ_TRANSACTIONS GLAT
, GMF_XLA_EXTRACT_HEADERS EH
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_B_KFV MSI
, XLE_ENTITY_PROFILES LE
WHERE EH.EVENT_TYPE_CODE IN ('LC_ADJUST_RECEIVE'
, 'LC_ADJUST_DELIVER'
, 'LC_ADJUST_EXP_DELIVER'
, 'LC_ADJUST_VALUATION')
AND EH.SOURCE_DOCUMENT_ID = GLAT.ADJ_TRANSACTION_ID
AND EH.SOURCE_LINE_ID = GLAT.RCV_TRANSACTION_ID
AND EH.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = EH.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = EH.INVENTORY_ITEM_ID
AND LE.LEGAL_ENTITY_ID = EH.LEGAL_ENTITY_ID
AND EH.EVENT_CLASS_CODE = 'LC_ADJUSTMENTS'