APPS.WMS_TASK_MGMT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1517: FROM mtl_system_items_b

1513: tracking_quantity_ind -- Added for Bug 16099247
1514: INTO l_lot_control_code ,
1515: l_serial_control_code,
1516: l_tracking_quantity_ind -- Added for Bug 16099247
1517: FROM mtl_system_items_b
1518: WHERE inventory_item_id = l_mmtt_inventory_item_id
1519: AND organization_id = l_mmtt_organization_id;
1520: x_lot_control_code := l_lot_control_code;
1521: x_serial_control_code := l_serial_control_code;

Line 3291: FROM mtl_system_items msi,

3287: SELECT msi.inventory_item_id ,
3288: msi.lot_control_code ,
3289: msi.serial_number_control_code,
3290: mmtt.parent_line_id
3291: FROM mtl_system_items msi,
3292: mtl_material_transactions_temp mmtt
3293: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
3294: AND msi.inventory_item_id = mmtt.inventory_item_id
3295: AND msi.organization_id = mmtt.organization_id;

Line 3558: FROM mtl_system_items

3554: SELECT 1,
3555: primary_uom_code
3556: INTO l_ato_item,
3557: l_primary_uom
3558: FROM mtl_system_items
3559: WHERE replenish_to_order_flag = 'Y'
3560: AND bom_item_type = 4
3561: AND inventory_item_id = l_mtl_reservation_tbl(1).inventory_item_id
3562: AND organization_id = l_mtl_reservation_tbl(1).organization_id;

Line 6739: from mtl_system_items

6735:
6736: CURSOR C_LOT_DIVISIBLE (p_item_id NUMBER,p_organization_id NUMBER )
6737: IS
6738: select lot_divisible_flag
6739: from mtl_system_items
6740: where inventory_item_id = p_item_id
6741: and organization_id = p_organization_id;
6742:
6743: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;