VIEW: APPS.MTL_ITEM_SUB_TRK_ALL_V

Source

View Text - Preformatted

SELECT SECONDARY_INVENTORY_NAME , SEC.ORGANIZATION_ID , INVENTORY_ITEM_ID , DESCRIPTION , INVENTORY_ATP_CODE , AVAILABILITY_TYPE , RESERVABLE_TYPE , LOCATOR_TYPE , SEC.PICKING_ORDER , MATERIAL_ACCOUNT , MATERIAL_OVERHEAD_ACCOUNT , RESOURCE_ACCOUNT , OVERHEAD_ACCOUNT , OUTSIDE_PROCESSING_ACCOUNT , QUANTITY_TRACKED , ASSET_INVENTORY , SEC.SOURCE_TYPE , SEC.SOURCE_SUBINVENTORY , SEC.SOURCE_ORGANIZATION_ID , REQUISITION_APPROVAL_TYPE , EXPENSE_ACCOUNT , SEC.ENCUMBRANCE_ACCOUNT , SEC.DISABLE_DATE , SEC.PROJECT_ID , SEC.TASK_ID , SEC.SUBINVENTORY_USAGE FROM MTL_SECONDARY_INVENTORIES SEC, MTL_ITEM_SUB_INVENTORIES ITEM WHERE SEC.SECONDARY_INVENTORY_NAME = ITEM.SECONDARY_INVENTORY AND SEC.ORGANIZATION_ID = ITEM.ORGANIZATION_ID AND QUANTITY_TRACKED = 1 AND (SEC.SUBINVENTORY_TYPE = 1 OR SEC.SUBINVENTORY_TYPE IS NULL)

View Text - HTML Formatted

SELECT SECONDARY_INVENTORY_NAME
, SEC.ORGANIZATION_ID
, INVENTORY_ITEM_ID
, DESCRIPTION
, INVENTORY_ATP_CODE
, AVAILABILITY_TYPE
, RESERVABLE_TYPE
, LOCATOR_TYPE
, SEC.PICKING_ORDER
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, QUANTITY_TRACKED
, ASSET_INVENTORY
, SEC.SOURCE_TYPE
, SEC.SOURCE_SUBINVENTORY
, SEC.SOURCE_ORGANIZATION_ID
, REQUISITION_APPROVAL_TYPE
, EXPENSE_ACCOUNT
, SEC.ENCUMBRANCE_ACCOUNT
, SEC.DISABLE_DATE
, SEC.PROJECT_ID
, SEC.TASK_ID
, SEC.SUBINVENTORY_USAGE
FROM MTL_SECONDARY_INVENTORIES SEC
, MTL_ITEM_SUB_INVENTORIES ITEM
WHERE SEC.SECONDARY_INVENTORY_NAME = ITEM.SECONDARY_INVENTORY
AND SEC.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND QUANTITY_TRACKED = 1
AND (SEC.SUBINVENTORY_TYPE = 1 OR SEC.SUBINVENTORY_TYPE IS NULL)