VIEW: APPS.INVFV_CYCLE_COUNT_ADJUSTMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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