View: INVFV_CYCLE_COUNT_ADJUSTMENTS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_CYCLE_COUNT_ADJUSTMENTS

View Text

SELECT MCE.CYCLE_COUNT_ENTRY_ID
, MCE.COUNT_DATE_FIRST
, MCE.COUNT_DATE_CURRENT
, MCE.COUNT_DATE_PRIOR
, MCE.COUNTED_BY_EMPLOYEE_ID_FIRST
, HR1.LAST_NAME
, MCE.COUNTED_BY_EMPLOYEE_ID_CURRENT
, HR2.LAST_NAME
, MCE.COUNTED_BY_EMPLOYEE_ID_PRIOR
, HR3.LAST_NAME
, MCE.COUNT_UOM_FIRST
, MCE.COUNT_UOM_CURRENT
, MCE.COUNT_UOM_PRIOR
, MCE.COUNT_QUANTITY_FIRST
, MCE.COUNT_QUANTITY_CURRENT
, MCE.COUNT_QUANTITY_PRIOR
, MCE.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, MCE.SUBINVENTORY
, '_LA:MCE.ENTRY_STATUS_CODE:MFG_LOOKUPS:MTL_CC_ENTRY_STATUSES:MEANING'
, MCE.COUNT_DUE_DATE
, MCE.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MCE.CYCLE_COUNT_HEADER_ID
, MCH.CYCLE_COUNT_HEADER_NAME
, MCE.NUMBER_OF_COUNTS
, MCE.LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, MCE.ADJUSTMENT_QUANTITY
, MCE.ADJUSTMENT_DATE
, MCE.ADJUSTMENT_AMOUNT
, MCE.ITEM_UNIT_COST
, MCE.INVENTORY_ADJUSTMENT_ACCOUNT
, '_KF:SQLGL:GL#:GLC'
, MCE.APPROVAL_DATE
, MCE.APPROVER_EMPLOYEE_ID
, HR4.LAST_NAME
, MCE.REVISION
, MCE.LOT_NUMBER
, MCE.LOT_CONTROL
, MCE.SYSTEM_QUANTITY_FIRST
, MCE.SYSTEM_QUANTITY_CURRENT
, MCE.SYSTEM_QUANTITY_PRIOR
, MCE.REFERENCE_FIRST
, MCE.REFERENCE_CURRENT
, MCE.REFERENCE_PRIOR
, MCE.PRIMARY_UOM_QUANTITY_FIRST
, MCE.PRIMARY_UOM_QUANTITY_CURRENT
, MCE.PRIMARY_UOM_QUANTITY_PRIOR
, '_LA:MCE.COUNT_TYPE_CODE:MFG_LOOKUPS:MTL_CC_COUNT_TYPES:MEANING'
, MCE.TRANSACTION_REASON_ID
, MTR.REASON_NAME
, '_LA:MCE.APPROVAL_TYPE:MFG_LOOKUPS:MTL_CC_APPROVAL_TYPES:MEANING'
, MCE.SERIAL_NUMBER
, '_LA:MCE.SERIAL_DETAIL:MFG_LOOKUPS:MTL_CC_SERIAL_DETAIL_OPTIONS:MEANING'
, '_LA:MCE.APPROVAL_CONDITION:MFG_LOOKUPS:MTL_CC_APPROVAL_CONDITION:MEANING'
, MCE.NEG_ADJUSTMENT_QUANTITY
, MCE.NEG_ADJUSTMENT_AMOUNT
, MCE.CREATED_BY
, MCE.CREATION_DATE
, MCE.LAST_UPDATED_BY
, MCE.LAST_UPDATE_DATE
FROM GL_CODE_COMBINATIONS GLC
, HR_EMPLOYEES HR1
, HR_EMPLOYEES HR2
, HR_EMPLOYEES HR3
, HR_EMPLOYEES HR4
, MTL_CYCLE_COUNT_HEADERS MCH
, MTL_ITEM_LOCATIONS MIL
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_SYSTEM_ITEMS MSI
, MTL_TRANSACTION_REASONS MTR
, MTL_CYCLE_COUNT_ENTRIES MCE
WHERE GLC.CODE_COMBINATION_ID (+) = MCE.INVENTORY_ADJUSTMENT_ACCOUNT
AND HR1.EMPLOYEE_ID (+) = MCE.COUNTED_BY_EMPLOYEE_ID_FIRST
AND HR2.EMPLOYEE_ID (+) = MCE.COUNTED_BY_EMPLOYEE_ID_CURRENT
AND HR3.EMPLOYEE_ID (+) = MCE.COUNTED_BY_EMPLOYEE_ID_PRIOR
AND HR4.EMPLOYEE_ID (+) = MCE.APPROVER_EMPLOYEE_ID
AND MCH.CYCLE_COUNT_HEADER_ID (+) = MCE.CYCLE_COUNT_HEADER_ID
AND MIL.ORGANIZATION_ID (+) = MCE.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = MCE.LOCATOR_ID
AND MP.ORGANIZATION_ID = MCE.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MCE.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MCE.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MCE.INVENTORY_ITEM_ID
AND MTR.REASON_ID (+) = MCE.TRANSACTION_REASON_ID
AND '_SEC:MCE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns