DBA Data[Home] [Help]

APPS.WMS_WIP_XDOCK_PVT dependencies on MTL_SYSTEM_ITEMS

Line 316: FROM mtl_txn_request_lines mol, mtl_system_items msi

312: , l_loc
313: , l_inspection_status
314: , l_line_id
315: , l_primary_uom
316: FROM mtl_txn_request_lines mol, mtl_system_items msi
317: WHERE lpn_id = l_lpn_id
318: AND line_id = NVL(p_move_order_line_id, line_id) -- added for ATF_J
319: AND mol.organization_id = l_org_id
320: AND mol.inventory_item_id = l_wip_item

Line 1447: FROM mtl_system_items

1443: SELECT lot_control_code
1444: , serial_number_control_code
1445: INTO v_lot_control_code
1446: , v_serial_control_code
1447: FROM mtl_system_items
1448: WHERE inventory_item_id = mmtt_row.inventory_item_id
1449: AND organization_id = mmtt_row.organization_id;
1450:
1451: SELECT allocate_serial_flag