VIEW: APPS.MTL_ONHAND_LOT_V

Source

View Text - Preformatted

SELECT a.organization_id, a.inventory_item_id, b.padded_concatenated_segments, a.revision, SUM (a.primary_transaction_quantity) total_qoh, a.subinventory_code, a.locator_id, a.lot_number lot, b.description item_description, b.primary_uom_code, c.organization_code, e.NAME organization_name, d.expiration_date, b.lot_control_code item_lot_control, b.location_control_code item_locator_control, b.serial_number_control_code item_serial_control /* INVCONV START rnrao */ ,d.grade_code grade_code, b.secondary_uom_code secondary_uom_code, SUM (a.secondary_transaction_quantity) secondary_total /* INVCONV END rnrao */ FROM mtl_onhand_quantities_detail a, mtl_system_items_kfv b, mtl_parameters c, mtl_lot_numbers d, hr_organization_units e WHERE a.inventory_item_id = b.inventory_item_id AND a.lot_number = d.lot_number AND a.inventory_item_id = d.inventory_item_id AND a.organization_id = b.organization_id AND a.organization_id = c.organization_id AND a.organization_id = d.organization_id AND a.organization_id = e.organization_id GROUP BY a.organization_id, a.inventory_item_id, a.revision, a.subinventory_code, a.locator_id, a.lot_number, b.padded_concatenated_segments, b.description, b.primary_uom_code, b.secondary_uom_code, c.organization_code, e.NAME, d.expiration_date, b.lot_control_code, b.location_control_code, b.serial_number_control_code, /* INVCONV START rnrao */ d.grade_code /* INVCONV END rnrao */

View Text - HTML Formatted

SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.PADDED_CONCATENATED_SEGMENTS
, A.REVISION
, SUM (A.PRIMARY_TRANSACTION_QUANTITY) TOTAL_QOH
, A.SUBINVENTORY_CODE
, A.LOCATOR_ID
, A.LOT_NUMBER LOT
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, E.NAME ORGANIZATION_NAME
, D.EXPIRATION_DATE
, B.LOT_CONTROL_CODE ITEM_LOT_CONTROL
, B.LOCATION_CONTROL_CODE ITEM_LOCATOR_CONTROL
, B.SERIAL_NUMBER_CONTROL_CODE ITEM_SERIAL_CONTROL /* INVCONV START RNRAO */
, D.GRADE_CODE GRADE_CODE
, B.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, SUM (A.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_TOTAL /* INVCONV END RNRAO */
FROM MTL_ONHAND_QUANTITIES_DETAIL A
, MTL_SYSTEM_ITEMS_KFV B
, MTL_PARAMETERS C
, MTL_LOT_NUMBERS D
, HR_ORGANIZATION_UNITS E
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.LOT_NUMBER = D.LOT_NUMBER
AND A.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.ORGANIZATION_ID = D.ORGANIZATION_ID
AND A.ORGANIZATION_ID = E.ORGANIZATION_ID GROUP BY A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.REVISION
, A.SUBINVENTORY_CODE
, A.LOCATOR_ID
, A.LOT_NUMBER
, B.PADDED_CONCATENATED_SEGMENTS
, B.DESCRIPTION
, B.PRIMARY_UOM_CODE
, B.SECONDARY_UOM_CODE
, C.ORGANIZATION_CODE
, E.NAME
, D.EXPIRATION_DATE
, B.LOT_CONTROL_CODE
, B.LOCATION_CONTROL_CODE
, B.SERIAL_NUMBER_CONTROL_CODE
, /* INVCONV START RNRAO */ D.GRADE_CODE /* INVCONV END RNRAO */