VIEW: INV.MTL_CC_ENTRIES_INTERFACE#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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