VIEW: INV.MTL_SECONDARY_INVENTORIES#

Source

View Text - Preformatted

select SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME, 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, DESCRIPTION DESCRIPTION, DISABLE_DATE DISABLE_DATE, INVENTORY_ATP_CODE INVENTORY_ATP_CODE, AVAILABILITY_TYPE AVAILABILITY_TYPE, RESERVABLE_TYPE RESERVABLE_TYPE, LOCATOR_TYPE LOCATOR_TYPE, PICKING_ORDER PICKING_ORDER, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT RESOURCE_ACCOUNT, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT, QUANTITY_TRACKED QUANTITY_TRACKED, ASSET_INVENTORY ASSET_INVENTORY, SOURCE_TYPE SOURCE_TYPE, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, REQUISITION_APPROVAL_TYPE REQUISITION_APPROVAL_TYPE, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, DEMAND_CLASS DEMAND_CLASS, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, SUBINVENTORY_USAGE SUBINVENTORY_USAGE, NOTIFY_LIST_ID NOTIFY_LIST_ID, PICK_UOM_CODE PICK_UOM_CODE, DEPRECIABLE_FLAG DEPRECIABLE_FLAG, LOCATION_ID LOCATION_ID, DEFAULT_COST_GROUP_ID DEFAULT_COST_GROUP_ID, STATUS_ID STATUS_ID, DEFAULT_LOC_STATUS_ID DEFAULT_LOC_STATUS_ID, LPN_CONTROLLED_FLAG LPN_CONTROLLED_FLAG, PICK_METHODOLOGY PICK_METHODOLOGY, CARTONIZATION_FLAG CARTONIZATION_FLAG, DROPPING_ORDER DROPPING_ORDER, SUBINVENTORY_TYPE SUBINVENTORY_TYPE, PLANNING_LEVEL PLANNING_LEVEL, DEFAULT_COUNT_TYPE_CODE DEFAULT_COUNT_TYPE_CODE, ENABLE_BULK_PICK ENABLE_BULK_PICK, ENABLE_LOCATOR_ALIAS ENABLE_LOCATOR_ALIAS, ENFORCE_ALIAS_UNIQUENESS ENFORCE_ALIAS_UNIQUENESS, ENABLE_OPP_CYC_COUNT ENABLE_OPP_CYC_COUNT, OPP_CYC_COUNT_DAYS OPP_CYC_COUNT_DAYS, OPP_CYC_COUNT_HEADER_ID OPP_CYC_COUNT_HEADER_ID, OPP_CYC_COUNT_QUANTITY OPP_CYC_COUNT_QUANTITY from "INV"."MTL_SECONDARY_INVENTORIES"

View Text - HTML Formatted

SELECT SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME
, 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
, DESCRIPTION DESCRIPTION
, DISABLE_DATE DISABLE_DATE
, INVENTORY_ATP_CODE INVENTORY_ATP_CODE
, AVAILABILITY_TYPE AVAILABILITY_TYPE
, RESERVABLE_TYPE RESERVABLE_TYPE
, LOCATOR_TYPE LOCATOR_TYPE
, PICKING_ORDER PICKING_ORDER
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, QUANTITY_TRACKED QUANTITY_TRACKED
, ASSET_INVENTORY ASSET_INVENTORY
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, REQUISITION_APPROVAL_TYPE REQUISITION_APPROVAL_TYPE
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, DEMAND_CLASS DEMAND_CLASS
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, SUBINVENTORY_USAGE SUBINVENTORY_USAGE
, NOTIFY_LIST_ID NOTIFY_LIST_ID
, PICK_UOM_CODE PICK_UOM_CODE
, DEPRECIABLE_FLAG DEPRECIABLE_FLAG
, LOCATION_ID LOCATION_ID
, DEFAULT_COST_GROUP_ID DEFAULT_COST_GROUP_ID
, STATUS_ID STATUS_ID
, DEFAULT_LOC_STATUS_ID DEFAULT_LOC_STATUS_ID
, LPN_CONTROLLED_FLAG LPN_CONTROLLED_FLAG
, PICK_METHODOLOGY PICK_METHODOLOGY
, CARTONIZATION_FLAG CARTONIZATION_FLAG
, DROPPING_ORDER DROPPING_ORDER
, SUBINVENTORY_TYPE SUBINVENTORY_TYPE
, PLANNING_LEVEL PLANNING_LEVEL
, DEFAULT_COUNT_TYPE_CODE DEFAULT_COUNT_TYPE_CODE
, ENABLE_BULK_PICK ENABLE_BULK_PICK
, ENABLE_LOCATOR_ALIAS ENABLE_LOCATOR_ALIAS
, ENFORCE_ALIAS_UNIQUENESS ENFORCE_ALIAS_UNIQUENESS
, ENABLE_OPP_CYC_COUNT ENABLE_OPP_CYC_COUNT
, OPP_CYC_COUNT_DAYS OPP_CYC_COUNT_DAYS
, OPP_CYC_COUNT_HEADER_ID OPP_CYC_COUNT_HEADER_ID
, OPP_CYC_COUNT_QUANTITY OPP_CYC_COUNT_QUANTITY
FROM "INV"."MTL_SECONDARY_INVENTORIES"