View: MTL_CC_ENTRIES_INTERFACE_V

Product:	INV - Inventory
Description:	Cycle Count Entries Interface View
Implementation/DBA Data:	APPS.MTL_CC_ENTRIES_INTERFACE_V

View Text

SELECT CCEOI.ROWID ROW_ID
, CCEOI.CC_ENTRY_INTERFACE_ID
, CCEOI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, CCEOI.LAST_UPDATE_DATE
, CCEOI.LAST_UPDATED_BY
, CCEOI.CREATION_DATE
, CCEOI.CREATED_BY
, CCEOI.LAST_UPDATE_LOGIN
, CCEOI.CC_ENTRY_INTERFACE_GROUP_ID
, CCEOI.CYCLE_COUNT_ENTRY_ID
, CCEOI.ACTION_CODE
, CCEOI.CYCLE_COUNT_HEADER_ID
, CCH.CYCLE_COUNT_HEADER_NAME
, CCEOI.COUNT_LIST_SEQUENCE
, CCEOI.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, CCEOI.ITEM_SEGMENT1
, CCEOI.ITEM_SEGMENT2
, CCEOI.ITEM_SEGMENT3
, CCEOI.ITEM_SEGMENT4
, CCEOI.ITEM_SEGMENT5
, CCEOI.ITEM_SEGMENT6
, CCEOI.ITEM_SEGMENT7
, CCEOI.ITEM_SEGMENT8
, CCEOI.ITEM_SEGMENT9
, CCEOI.ITEM_SEGMENT10
, CCEOI.ITEM_SEGMENT11
, CCEOI.ITEM_SEGMENT12
, CCEOI.ITEM_SEGMENT13
, CCEOI.ITEM_SEGMENT14
, CCEOI.ITEM_SEGMENT15
, CCEOI.ITEM_SEGMENT16
, CCEOI.ITEM_SEGMENT17
, CCEOI.ITEM_SEGMENT18
, CCEOI.ITEM_SEGMENT19
, CCEOI.ITEM_SEGMENT20
, CCEOI.REVISION
, CCEOI.SUBINVENTORY
, CCEOI.LOCATOR_ID
, CCEOI.LOCATOR_SEGMENT1
, CCEOI.LOCATOR_SEGMENT2
, CCEOI.LOCATOR_SEGMENT3
, CCEOI.LOCATOR_SEGMENT4
, CCEOI.LOCATOR_SEGMENT5
, CCEOI.LOCATOR_SEGMENT6
, CCEOI.LOCATOR_SEGMENT7
, CCEOI.LOCATOR_SEGMENT8
, CCEOI.LOCATOR_SEGMENT9
, CCEOI.LOCATOR_SEGMENT10
, CCEOI.LOCATOR_SEGMENT11
, CCEOI.LOCATOR_SEGMENT12
, CCEOI.LOCATOR_SEGMENT13
, CCEOI.LOCATOR_SEGMENT14
, CCEOI.LOCATOR_SEGMENT15
, CCEOI.LOCATOR_SEGMENT16
, CCEOI.LOCATOR_SEGMENT17
, CCEOI.LOCATOR_SEGMENT18
, CCEOI.LOCATOR_SEGMENT19
, CCEOI.LOCATOR_SEGMENT20
, CCEOI.LOT_NUMBER
, CCEOI.SERIAL_NUMBER
, CCEOI.PRIMARY_UOM_QUANTITY
, MSI.PRIMARY_UOM_CODE
, CCEOI.COUNT_UOM
, CCEOI.COUNT_UNIT_OF_MEASURE
, CCEOI.COUNT_QUANTITY
, CCEOI.SYSTEM_QUANTITY
, CCEOI.ADJUSTMENT_ACCOUNT_ID
, CCEOI.ACCOUNT_SEGMENT1
, CCEOI.ACCOUNT_SEGMENT2
, CCEOI.ACCOUNT_SEGMENT3
, CCEOI.ACCOUNT_SEGMENT4
, CCEOI.ACCOUNT_SEGMENT5
, CCEOI.ACCOUNT_SEGMENT6
, CCEOI.ACCOUNT_SEGMENT7
, CCEOI.ACCOUNT_SEGMENT8
, CCEOI.ACCOUNT_SEGMENT9
, CCEOI.ACCOUNT_SEGMENT10
, CCEOI.ACCOUNT_SEGMENT11
, CCEOI.ACCOUNT_SEGMENT12
, CCEOI.ACCOUNT_SEGMENT13
, CCEOI.ACCOUNT_SEGMENT14
, CCEOI.ACCOUNT_SEGMENT15
, CCEOI.ACCOUNT_SEGMENT16
, CCEOI.ACCOUNT_SEGMENT17
, CCEOI.ACCOUNT_SEGMENT18
, CCEOI.ACCOUNT_SEGMENT19
, CCEOI.ACCOUNT_SEGMENT20
, CCEOI.ACCOUNT_SEGMENT21
, CCEOI.ACCOUNT_SEGMENT22
, CCEOI.ACCOUNT_SEGMENT23
, CCEOI.ACCOUNT_SEGMENT24
, CCEOI.ACCOUNT_SEGMENT25
, CCEOI.ACCOUNT_SEGMENT26
, CCEOI.ACCOUNT_SEGMENT27
, CCEOI.ACCOUNT_SEGMENT28
, CCEOI.ACCOUNT_SEGMENT29
, CCEOI.ACCOUNT_SEGMENT30
, CCEOI.COUNT_DATE
, CCEOI.EMPLOYEE_ID
, CCEOI.EMPLOYEE_FULL_NAME
, CCEOI.REFERENCE
, CCEOI.TRANSACTION_REASON_ID
, CCEOI.TRANSACTION_REASON
, CCEOI.REQUEST_ID
, CCEOI.PROGRAM_APPLICATION_ID
, CCEOI.PROGRAM_ID
, CCEOI.PROGRAM_UPDATE_DATE
, CCEOI.LOCK_FLAG
, CCEOI.PROCESS_FLAG
, CCEOI.PROCESS_MODE
, CCEOI.VALID_FLAG
, CCEOI.DELETE_FLAG
, CCEOI.STATUS_FLAG
, CCEOI.ERROR_FLAG
, CCEOI.ATTRIBUTE_CATEGORY
, CCEOI.ATTRIBUTE1
, CCEOI.ATTRIBUTE2
, CCEOI.ATTRIBUTE3
, CCEOI.ATTRIBUTE4
, CCEOI.ATTRIBUTE5
, CCEOI.ATTRIBUTE6
, CCEOI.ATTRIBUTE7
, CCEOI.ATTRIBUTE8
, CCEOI.ATTRIBUTE9
, CCEOI.ATTRIBUTE10
, CCEOI.ATTRIBUTE11
, CCEOI.ATTRIBUTE12
, CCEOI.ATTRIBUTE13
, CCEOI.ATTRIBUTE14
, CCEOI.ATTRIBUTE15
, CCEOI.PROJECT_ID
, CCEOI.TASK_ID
, CCEOI.PARENT_LPN_ID
, CCEOI.PARENT_LPN
, CCEOI.OUTERMOST_LPN_ID
, LPN.LICENSE_PLATE_NUMBER OUTERMOST_LPN
, CCEOI.COST_GROUP_ID
, CCEOI.COST_GROUP_NAME
, CCEOI.SECONDARY_UOM
, CCEOI.SECONDARY_UNIT_OF_MEASURE
, CCEOI.SECONDARY_COUNT_QUANTITY
, CCEOI.SECONDARY_SYSTEM_QUANTITY
FROM MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HOU
, MTL_CYCLE_COUNT_HEADERS CCH
, MTL_CC_ENTRIES_INTERFACE CCEOI
, WMS_LICENSE_PLATE_NUMBERS LPN
WHERE MSI.ORGANIZATION_ID(+) = CCEOI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID (+) = CCEOI.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID(+) = CCEOI.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID(+) = CCEOI.ORGANIZATION_ID
AND CCH.CYCLE_COUNT_HEADER_ID(+) = CCEOI.CYCLE_COUNT_HEADER_ID
AND LPN.LPN_ID(+) = CCEOI.OUTERMOST_LPN_ID

Columns