VIEW: APPS.GMF_XLA_LOTCOST_ADJS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'