VIEW: APPS.MTL_REPLENISH_LINES_VIEW

Source

View Text - Preformatted

SELECT MTL_REPLENISH_LINES.ROWID , REPLENISHMENT_LINE_ID , REPLENISHMENT_HEADER_ID , MTL_REPLENISH_LINES.ORGANIZATION_ID , MTL_REPLENISH_LINES.LAST_UPDATE_DATE , MTL_REPLENISH_LINES.LAST_UPDATED_BY , MTL_REPLENISH_LINES.CREATION_DATE , MTL_REPLENISH_LINES.CREATED_BY , MTL_REPLENISH_LINES.LAST_UPDATE_LOGIN , MTL_SYSTEM_ITEMS.SEGMENT1 , MTL_REPLENISH_LINES.INVENTORY_ITEM_ID , COUNT_TYPE_CODE , COUNT_QUANTITY , COUNT_UOM_CODE , SUPPLY_QUANTITY , MTL_REPLENISH_LINES.SOURCE_TYPE , MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID , MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY , REORDER_QUANTITY , MTL_REPLENISH_LINES.EXPENSE_ACCOUNT , MTL_REPLENISH_LINES.ENCUMBRANCE_ACCOUNT , REFERENCE , ERROR_FLAG , MTL_REPLENISH_LINES.REQUEST_ID , MTL_REPLENISH_LINES.PROGRAM_APPLICATION_ID , MTL_REPLENISH_LINES.PROGRAM_ID , MTL_REPLENISH_LINES.PROGRAM_UPDATE_DATE , PRIMARY_UOM_COUNT_QUANTITY , MTL_REPLENISH_LINES.PRIMARY_UOM_CODE , MTL_SYSTEM_ITEMS.DESCRIPTION , MEANING , TASK_ID , LOCATOR_ID , TO_NUMBER(NULL) FROM MTL_REPLENISH_LINES, MTL_SYSTEM_ITEMS, MFG_LOOKUPS WHERE MTL_REPLENISH_LINES.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = MTL_REPLENISH_LINES.ORGANIZATION_ID AND LOOKUP_TYPE (+) = 'MTL_REPLENISHMENT_ERROR' AND LOOKUP_CODE (+) = ERROR_FLAG AND LOCATOR_ID IS NULL UNION ALL SELECT MTL_REPLENISH_LINES.ROWID , REPLENISHMENT_LINE_ID , REPLENISHMENT_HEADER_ID , MTL_REPLENISH_LINES.ORGANIZATION_ID , MTL_REPLENISH_LINES.LAST_UPDATE_DATE , MTL_REPLENISH_LINES.LAST_UPDATED_BY , MTL_REPLENISH_LINES.CREATION_DATE , MTL_REPLENISH_LINES.CREATED_BY , MTL_REPLENISH_LINES.LAST_UPDATE_LOGIN , MTL_SYSTEM_ITEMS.SEGMENT1 , MTL_REPLENISH_LINES.INVENTORY_ITEM_ID , COUNT_TYPE_CODE , COUNT_QUANTITY , COUNT_UOM_CODE , SUPPLY_QUANTITY , MTL_REPLENISH_LINES.SOURCE_TYPE , MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID , MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY , REORDER_QUANTITY , MTL_REPLENISH_LINES.EXPENSE_ACCOUNT , MTL_REPLENISH_LINES.ENCUMBRANCE_ACCOUNT , REFERENCE , ERROR_FLAG , MTL_REPLENISH_LINES.REQUEST_ID , MTL_REPLENISH_LINES.PROGRAM_APPLICATION_ID , MTL_REPLENISH_LINES.PROGRAM_ID , MTL_REPLENISH_LINES.PROGRAM_UPDATE_DATE , PRIMARY_UOM_COUNT_QUANTITY , MTL_REPLENISH_LINES.PRIMARY_UOM_CODE , MTL_SYSTEM_ITEMS.DESCRIPTION , MEANING , MTL_REPLENISH_LINES.TASK_ID , MTL_REPLENISH_LINES.LOCATOR_ID , MTL_ITEM_LOCATIONS.PICKING_ORDER FROM MTL_REPLENISH_LINES , MTL_SYSTEM_ITEMS , MTL_ITEM_LOCATIONS , MFG_LOOKUPS WHERE MTL_REPLENISH_LINES.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = MTL_REPLENISH_LINES.ORGANIZATION_ID AND MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID = MTL_REPLENISH_LINES.LOCATOR_ID AND MTL_ITEM_LOCATIONS.ORGANIZATION_ID = MTL_REPLENISH_LINES.ORGANIZATION_ID AND LOOKUP_TYPE(+) = 'MTL_REPLENISHMENT_ERROR' AND LOOKUP_CODE(+) = ERROR_FLAG AND LOCATOR_ID IS NOT NULL

View Text - HTML Formatted

SELECT MTL_REPLENISH_LINES.ROWID
, REPLENISHMENT_LINE_ID
, REPLENISHMENT_HEADER_ID
, MTL_REPLENISH_LINES.ORGANIZATION_ID
, MTL_REPLENISH_LINES.LAST_UPDATE_DATE
, MTL_REPLENISH_LINES.LAST_UPDATED_BY
, MTL_REPLENISH_LINES.CREATION_DATE
, MTL_REPLENISH_LINES.CREATED_BY
, MTL_REPLENISH_LINES.LAST_UPDATE_LOGIN
, MTL_SYSTEM_ITEMS.SEGMENT1
, MTL_REPLENISH_LINES.INVENTORY_ITEM_ID
, COUNT_TYPE_CODE
, COUNT_QUANTITY
, COUNT_UOM_CODE
, SUPPLY_QUANTITY
, MTL_REPLENISH_LINES.SOURCE_TYPE
, MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID
, MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY
, REORDER_QUANTITY
, MTL_REPLENISH_LINES.EXPENSE_ACCOUNT
, MTL_REPLENISH_LINES.ENCUMBRANCE_ACCOUNT
, REFERENCE
, ERROR_FLAG
, MTL_REPLENISH_LINES.REQUEST_ID
, MTL_REPLENISH_LINES.PROGRAM_APPLICATION_ID
, MTL_REPLENISH_LINES.PROGRAM_ID
, MTL_REPLENISH_LINES.PROGRAM_UPDATE_DATE
, PRIMARY_UOM_COUNT_QUANTITY
, MTL_REPLENISH_LINES.PRIMARY_UOM_CODE
, MTL_SYSTEM_ITEMS.DESCRIPTION
, MEANING
, TASK_ID
, LOCATOR_ID
, TO_NUMBER(NULL)
FROM MTL_REPLENISH_LINES
, MTL_SYSTEM_ITEMS
, MFG_LOOKUPS
WHERE MTL_REPLENISH_LINES.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = MTL_REPLENISH_LINES.ORGANIZATION_ID
AND LOOKUP_TYPE (+) = 'MTL_REPLENISHMENT_ERROR'
AND LOOKUP_CODE (+) = ERROR_FLAG
AND LOCATOR_ID IS NULL UNION ALL SELECT MTL_REPLENISH_LINES.ROWID
, REPLENISHMENT_LINE_ID
, REPLENISHMENT_HEADER_ID
, MTL_REPLENISH_LINES.ORGANIZATION_ID
, MTL_REPLENISH_LINES.LAST_UPDATE_DATE
, MTL_REPLENISH_LINES.LAST_UPDATED_BY
, MTL_REPLENISH_LINES.CREATION_DATE
, MTL_REPLENISH_LINES.CREATED_BY
, MTL_REPLENISH_LINES.LAST_UPDATE_LOGIN
, MTL_SYSTEM_ITEMS.SEGMENT1
, MTL_REPLENISH_LINES.INVENTORY_ITEM_ID
, COUNT_TYPE_CODE
, COUNT_QUANTITY
, COUNT_UOM_CODE
, SUPPLY_QUANTITY
, MTL_REPLENISH_LINES.SOURCE_TYPE
, MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID
, MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY
, REORDER_QUANTITY
, MTL_REPLENISH_LINES.EXPENSE_ACCOUNT
, MTL_REPLENISH_LINES.ENCUMBRANCE_ACCOUNT
, REFERENCE
, ERROR_FLAG
, MTL_REPLENISH_LINES.REQUEST_ID
, MTL_REPLENISH_LINES.PROGRAM_APPLICATION_ID
, MTL_REPLENISH_LINES.PROGRAM_ID
, MTL_REPLENISH_LINES.PROGRAM_UPDATE_DATE
, PRIMARY_UOM_COUNT_QUANTITY
, MTL_REPLENISH_LINES.PRIMARY_UOM_CODE
, MTL_SYSTEM_ITEMS.DESCRIPTION
, MEANING
, MTL_REPLENISH_LINES.TASK_ID
, MTL_REPLENISH_LINES.LOCATOR_ID
, MTL_ITEM_LOCATIONS.PICKING_ORDER
FROM MTL_REPLENISH_LINES
, MTL_SYSTEM_ITEMS
, MTL_ITEM_LOCATIONS
, MFG_LOOKUPS
WHERE MTL_REPLENISH_LINES.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = MTL_REPLENISH_LINES.ORGANIZATION_ID
AND MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID = MTL_REPLENISH_LINES.LOCATOR_ID
AND MTL_ITEM_LOCATIONS.ORGANIZATION_ID = MTL_REPLENISH_LINES.ORGANIZATION_ID
AND LOOKUP_TYPE(+) = 'MTL_REPLENISHMENT_ERROR'
AND LOOKUP_CODE(+) = ERROR_FLAG
AND LOCATOR_ID IS NOT NULL