VIEW: APPS.MTL_CC_ENTRIES_INTERFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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