APPS.WMS_TASK_MGMT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1507: FROM mtl_system_items_b

1503: SELECT lot_control_code ,
1504: serial_number_control_code
1505: INTO l_lot_control_code ,
1506: l_serial_control_code
1507: FROM mtl_system_items_b
1508: WHERE inventory_item_id = l_mmtt_inventory_item_id
1509: AND organization_id = l_mmtt_organization_id;
1510: x_lot_control_code := l_lot_control_code;
1511: x_serial_control_code := l_serial_control_code;

Line 3202: FROM mtl_system_items msi,

3198: SELECT msi.inventory_item_id ,
3199: msi.lot_control_code ,
3200: msi.serial_number_control_code,
3201: mmtt.parent_line_id
3202: FROM mtl_system_items msi,
3203: mtl_material_transactions_temp mmtt
3204: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
3205: AND msi.inventory_item_id = mmtt.inventory_item_id
3206: AND msi.organization_id = mmtt.organization_id;

Line 3469: FROM mtl_system_items

3465: SELECT 1,
3466: primary_uom_code
3467: INTO l_ato_item,
3468: l_primary_uom
3469: FROM mtl_system_items
3470: WHERE replenish_to_order_flag = 'Y'
3471: AND bom_item_type = 4
3472: AND inventory_item_id = l_mtl_reservation_tbl(1).inventory_item_id
3473: AND organization_id = l_mtl_reservation_tbl(1).organization_id;

Line 6644: from mtl_system_items

6640:
6641: CURSOR C_LOT_DIVISIBLE (p_item_id NUMBER,p_organization_id NUMBER )
6642: IS
6643: select lot_divisible_flag
6644: from mtl_system_items
6645: where inventory_item_id = p_item_id
6646: and organization_id = p_organization_id;
6647:
6648: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;