View: GMF_XLA_LC_ADJS_V

Product:	GMF - Process Manufacturing Financials
Description:	SLA LC Adjustments view, used to display LC adjustments information in accounting events screen
Implementation/DBA Data:	APPS.GMF_XLA_LC_ADJS_V

View Text

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'

Columns