DBA Data[Home] [Help]

APPS.WSH_SC_PLD_PKG dependencies on MTL_SYSTEM_ITEMS

Line 51: FROM mtl_system_items msi,

47:
48: -- to check if the item is under serial number control
49: CURSOR check_serial(X_Pk_Line_Detail_Id NUMBER) is
50: SELECT msi.serial_number_control_code
51: FROM mtl_system_items msi,
52: so_picking_lines_all pl,
53: so_picking_line_details pld
54: WHERE pl.inventory_item_id = msi.inventory_item_id
55: AND pl.warehouse_id = msi.organization_id